Question

1 Approved Answer

Posted on Sep 25, 2024

Which one of the following statements pulksal the data from the Order Details table? Me Onder Product Une te Quantity Deco 1 10000 11 14.00

Which one of the following statements pulksal the data from the Order Details table? Me Onder Product Une te Quantity Deco 1 10000 11 14.00 12 2 10240 12 9.30 10 3 10249 72 34.80 5 0 4 10249 14 18.60 9 O SELECT ALL FROM [Order Details: O SELECT FROM [Order Details: O SELECT ALL DATA FROM (Order Details: O SELECT DATA FROM [Order Details: D 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 Order Customer D Order Date Frecht 10510 QUICK 1997-05-19 00 00 00 000 100764 2 10372 QUEEN 1996-12-04 00.00.00.000 190.78 3 11030 SAVEA 1958-04-17 00.00.00 000 83073 10591 QUICK 1997-10-03 00 00 00 000 810.05 5 10514 ERNSH 1997-04-22.00-00-00 000 79995 O SELECT Order, Customer. Order Date Freiht. City FROM Orders DESC ORDER BY Freight: SELECT Order, Customeri, Order Date Free FROM Orders O SELECT OrderID, Custom Orde Date Free FROM Orders HAVING Freight DESC SELECT Order. Cuntomer ordet Fils FROM O 10 pts Question 10 Which of the following statements displays the 5 oldest orders from the orders table as illustrated below? 1 2. 3 4 5. Results Messages OrderiD Order Date Today's Date Order's Age 10248 1996-07-04 00:00:00.000 2019-08-17 03:51.46.493 8444 10249 1996-07-05 00:00:00.000 2019-08-17 03:51:46 493 8443 10250 1996-07-08 00.00.00.000 2019-08-17 03:51-46.493 8440 10251 1996-07-08 00:00:00.000 2019-08-17 03:51:46 493 8440 10252 1996-07-09 00:00:00.000 2019-08-17 03.51.46.493 3439 SELECT OrderID. OrderDate, GETDATE() AS Today's Dates DATEDIFF (day. Order Date, GETDATED) AS [Order's Age) FROM Orders ORDER TOP 5: SELECT TOP 5 Orderib. Order Date, DATEDIFFO AS Today's Date DATEDIFF (day, Order Date. GETDATEOSAS (Order's Age! FROM Orders: O SELECT TOP 5 OrderID Order Date GETDATE() AS Todays Date DATEDIFF (day. Order Date GETDATEDYAS [Order's Age FROM Orders O SELECT TOP 5 Order Order Date, GETDATED AS Today's Date DATEDIFF(day, Order Date, GETDATEOYAS Orders Are FROM Orders Which one of the folowing statements generates the temporary columns shown in the result set below? Red D PRICE PER Query 1030 14.00 12 2 10240 9.80 10 3 10240 3.80 4 104 18.50 5 10049 2.40 G 10250 770 SELECT OrderID AS ID, UnitPrice AS (PRKE PERI. Quantity From (Order Detail O SELECT OrderID AS IO, UnitPrice AS PRICE PER Quantity From Order Detail O SELECT Order ID AS ID, UnitPrice AS (PRICE PERI. Quantity From Order Detail O SELECT OrderID AS ID, UnitPrice AS [PRICE PERI. Quantity From Order Details: Question 6 10 pts Which of the following statements displays all orders in the orders table with a Null shipping date? Ret Message Order COM Ree Shie 11001 ERNSH 19956400000000000 1990 5 000 000 000 NAL 11013 RANCH 1396 04-13 00 00 00 19920511000 CCOO NOLE 11013 LINOD 1101000000000193005-19 00 00 00 00 NULL 11040 GREAL 1998-04-32000000000 1998 05 2000 2000 NULL 11045 BOTTM 1990042100000000-05 2100.000 NEL 11051 MA 1930427090000.000 1991-0500-0000000 O SELECT FROM Orders WHERE ShippedDate > NULL SELECT FROM Orders WHERE ShippedDatei NULL O SELECT FROM Others WERED NULL SELECT WHORE SPADLOM MLL FROM O Which one of the following statements llinates the duplicate rows from displaying in the result set? Rube Courty Now 1 2 4 5 6 Belgen Ba Canada Derma SELECT Country FROM Customers ORDER BY Country: O SELECT Country FROM Quito ORDER BY DISTINCT Country O SELECT DISTINCT Country FROM Customers ORDER BY Country: SELECT DISTINCT Country FROM Customers DISTINCT BY Country D Question 8 10 pts Which of the following statements produces the result set below? Real Messages FUN Nancy Davo 2 Andrew Fuller 3 Janet levering 4 Marguet Peacock 5 Steven Buchanan SELECT FirstName+ Last AS [Full Manel FROM Employees O SELECT stane ASIF Name FROM Eos SELECT First Nainen AS FUN FROM Employee O SELECT Tutti