Question

Below is the database schema for a company. Primary keys are underlined. Customers (CustomerID, CompanyName, Phone, BalanceDue) Oders (Orderid, orderdate, customerid, freightamount) Orderdetails (oderid, productid, qtyordered, price) Products (productid, productname, qtyinstock, suggestedprice, minstocklevel) Given this SQL statement: Select * From Customers Inner Join Orders on Orders.CustomerID=Customers.CustomerID Where Orders.CustomerID is Null; Which of the following statement is correct?

It is a SQL select statement that will list the ProductName for all products where the Qtyinstock is less than the total QtyOrdered (in OrderDetails) of that product.

It is a SQL select statement that will list all customers who have not placed any order.

It is a SQL select statement that will list the most expensive (highest suggested price) product's name, and its suggested price.

It is a SQL select statement that will list in alphabetical order, the ProductName of all products where the Qtystock is less than 10.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question :

Answer :It is a SQL select statement that will list all customers who have not placed any order.

Explanation :

• Given sql statement will join Customers and orders table based on CustomerID
• and will return the records for orders where customer is null.
• This means SQL select statement that will list all customers who have not placed any order.

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.