> Question 9 Which one of these statements displays the following countries from the orders table? Results Messages Ship

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
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

Post by answerhappygod »

Question 9 Which One Of These Statements Displays The Following Countries From The Orders Table Results Messages Ship 1
Question 9 Which One Of These Statements Displays The Following Countries From The Orders Table Results Messages Ship 1 (160.59 KiB) Viewed 48 times
> 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply