> Question 9 Which one of these statements displays the following countries from the orders table? Results Messages Ship
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
> Question 9 Which one of these statements displays the following countries from the orders table? Results Messages Ship
Question 9 Which one of these statements displays the following countries from the orders table? Results Messages ShipCity ShipCountry 1 San Cristóbal Venezuela 2 Graz Austria 3 Albuquerque USA 4 Graz Austria 5 Caracas Venezuela 6 Seattle USA 7 Lander USA 8 Albuquerque USA 9 Barquisimeto Venezuela 10 Albuquerque USA O SELECT ShipCity, ShipCountry FROM Orders WHERE ShipCountry Like 'A%A'; O SELECT ShipCity, ShipCountry FROM Orders WHERE ShipCountry Like '%A"; O SELECT ShipCity, ShipCountry FROM Orders WHERE ShipCountry Like 'A'; O SELECT ShipCity, ShipCountry FROM Orders WHERE ShipCountry Like 'A%"; D Question 10 10 pts Which of the following statements displays the 5 oldest orders from the orders table as illustrated below? Results Messages OrderID OrderDate Today's Date Order's Age 1 10248 2019-08-17 03:51:46.493 8444 2019-08-17 03:51:46.493 8443 2 10249 3 10250 1996-07-04 00:00:00.000 1996-07-05 00:00:00.000 1996-07-08 00:00:00.000 10251 1996-07-08 00:00:00.000 10252 1996-07-09 00:00:00.000 4 2019-08-17 03:51:46.493 8440 2019-08-17 03:51:46.493 8440 2019-08-17 03:51:46.493 8439 5 O SELECT OrderID, OrderDate, GETDATE() AS 'Today's Date DATEDIFF (day, OrderDate, GETDATE()) AS [Order's Age] FROM Orders ORDER TOP 5: O SELECT TOP 5 OrderID, Order Date, DATEDIFF() AS 'Today's Date, DATEDIFF (day, Order Date, GETDATE()) AS [Order's Age] FROM Orders; O SELECT TOP 5 OrderID, Order Date, GETDATE() AS 'Today's Date, DATEDIFF (day, Order Date, GETDATE()) AS [Order's Age] FROM Orders; O SELECT TOP 5 OrderID, Order Date, GETDATE() AS 'Today's Date, DATEDIFF (day, OrderDate, GETDATE()) AS [Order's Age] FROM Orders; 10 pts
>