Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Write a SELECT statement that returns these columns from the Orders table: -The OrderID column -The OrderDate column - ApproxShipDate , which is a column

Write a SELECT statement that returns these columns from the Orders table:

-The OrderID column -The OrderDate column -ApproxShipDate, which is a column calculated by adding 2 days to the OrderDate column -The ShipDate column -DaysToShip, which is a column that shows the number of days between the order date and the ship date

When you have this working, add a WHERE clause that retrieves just the orders for March 2016.

Below is a snippet from the Orders table:

image text in transcribed

Results Messages ShipAmount TaxAmount ShipDate 58.75 21.27 02.29 117.50 20.93 20.93 107.80 47.60 102.75 OrderID CustomerlD OrderDate ShipAddressID CardType CardNumber CardExpires Bl 2016-03-28 09:40:28.000 5.00 2016-03-28 11:23:20.000 5.00 2016-03-29 09:44:58.000 10.00 2016-03-30 15:22:31.000 10.00 2016-03-31 05:43:11.000 5.00 2016-03-31 18:37:22.000 5.00 2016-04-01 23:11:12.000 15.00 2016-04-02 11:26:38.000 5.00 2016-04-03 12:22:31.000 15.00 2016-03-31 09:41:11.0001 2016-03-31 11:24:03.000 3 2016-04-01 09:45:41.000 1 2016-04-02 15:23:14.000 4 2016-04-03 05:43:54.000 5 2016-04-03 18:38:05.000 7 2016-04-04 23:11:55.000 8 2016-04-05 11:27:21.000 9 2016-04-06 12:23:14.000 5 Visa 2 4012888888881881 08/2020 3 Visa American Express 3782822463100005 02/2017 4 Visa MasterCard 5555555555554444 12/2018 8 4012888888881881 04/2017 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

=+8.4. Show that B 8 [W] k-0 n=1m=1 A-1

Answered: 1 week ago