4. Write a SELECT statement that returns four columns from the Sales.Order table

Question

4. Write a SELECT statement that returns four columns from the Sales.Order table: orderid, custid, orderdate, and shipcountry. The orderdate is currently in the datetime format. Cast the orderdate as a date. Filter the result set to return only records from Venezuela that have not been shipped. Here are the columns: [orderdate], [requireddate], [shippeddate], [orderid], [custid], [shipcountry] Here is my query: SELECT orderid, custid, CAST(orderdate AS DATE) AS orderdate, shipcountry FROM Sales.Orders WHERE shipcountry = 'Venezuela' and requireddate > shippeddate;

Explanation / Answer

The correct query should be:

SELECT orderid, custid, CAST(orderdate AS DATE) AS orderdate, shipcountry FROM Sales.Order WHERE shipcountry = 'Venezuela' and shippeddate is null;

Not shipped clearly means, the ship date column will be empty.

Let me know if this doesn't work. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.