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;