Question 1 Which one of the following statements pulls all the data from the [Order Details] table? Results Messages Ord

[answerhappygod]

Question 1 Which One Of The Following Statements Pulls All The Data From The Order Details Table Results Messages Ord 1 (121.56 KiB) Viewed 36 times

Question 1 Which One Of The Following Statements Pulls All The Data From The Order Details Table Results Messages Ord 2 (148.53 KiB) Viewed 36 times

Question 1 Which one of the following statements pulls all the data from the [Order Details] table? Results Messages OrderID Product ID Unit Price Quantity Discount 0 10248 11 14.00 12 10248 42 9.80 10 10248 72 34.80 10249 14 18.60 SELECT ALL FROM [Order Details]; SELECT * FROM [Order Details]; FROM [Order Details]; FROM [Order Details]; 1 2 3 4 O SELECT ALL DATA O SELECT DATA 2259 1 2 OOOO 0 0 0 10 pts Question 2 10 pts Which one of the following statements pulls four columns from the orders table, sorts the result set in descending sequence by Freight? Results Messages OrderID CustomerID Order Date Freight 10540 QUICK 10372 QUEEN 3 11030 SAVEA 10691 QUICK 1997-05-19 00:00:00.000 1007.64 1996-12-04 00:00:00.000 890.78 1998-04-17 00:00:00.000 830.75 1997-10-03 00:00:00.000 810.05 1997-04-22 00:00:00.000 789.95 4 5 10514 ERNSH O SELECT OrderID, CustomerID, Order Date, Freight, City FROM Orders DESC ORDER BY Freight; SELECT OrderID, CustomerID, Order Date, Freight FROM Orders; SELECT OrderID, CustomerID, Order Date, Freight FROM Orders HAVING Freight DESC; O SELECT OrderlD, CustomerID, OrderDate, Freight FROM Orders ORDER BY Freight DESC;

D Question 3 Which of the following statements pulls all the orders between the given dates? Results Messages OrderID CustomerID OrderDate 1 10806 VICTE 1997-12-31 00:00:00.000 1997-12-31 00:00:00.000 2 10807 FRANS 10808 OLDWO 10809 WELLI 3 1998-01-01 00:00:00.000 4 1998-01-01 00:00:00.000 5 10810 LAUGB 1998-01-01 00:00:00.000 O SELECT OrderID, CustomerID, OrderDate FROM Orders WHERE OrderDate BETWEEN '1997-12-31' AND '1998-05-04 ORDER BY Order Date; O SELECT OrderID, CustomerID, Order Date FROM Orders WHERE OrderDate THROUGH '1997-12-31' AND '1998-05-04 ORDER BY OrderDate; O SELECT OrderID, CustomerID, OrderDate FROM Orders WHERE OrderDate THROUGH 1997-12-31 AND 1998-05-04 ORDER BY OrderDate; O SELECT OrderID, CustomerID, Order Date FROM Orders WHERE OrderDate BETWEEN '1997-12-31' DATEDIFF 1998-05-04 ORDER BY OrderDate: Question 4 Which of the following statements will display the result set below? Results Messages OrderID Unit Price Quantity Order Total 1 10462 4.80 1 4.80 2 10281 7.30 1 7,30 3 10420 4.80 2 9.60 4 2.50 4 10.00 10850 10782 5 12.50 1 12.50 6 10623 4.50 3 13.50 7 11038 7.00 2 14.00 O SELECT OrderID, UnitPrice, Quantity, UnitPrice Quantity AS Order Total From [Order Details] ORDER BY Order Total DESC; O SELECT OrderID, UnitPrice, Quantity, UnitPrice Quantity AS Order Total From [Order Details] ORDER BY Order Total; O SELECT OrderlD, UnitPrice, Quantity. UnitPrice Quantity AS Order Total From [Order Details] ORDER BY Quantity DESC; O SELECT OrderID, UnitPrice, Quantity, UnitPrice + Quantity AS OrderTotal From [Order Details] ORDER BY Order Total; 10 pts 10 pts