Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a SELECT statement that returns these columns from the Orders table: order_id The order_id column order_date The order_date column ship_date The ship_date column ship_amount
Write a SELECT statement that returns these columns from the Orders table:
order_id The order_id column order_date The order_date column ship_date The ship_date column ship_amount The ship_amount column
Return only the rows where the ship_date column contains a null value and ship_amount does not contain a null value.
order_id | order_date | ship_date | ship_amount |
6 | 2018-03-31 18:37:22 | NULL | 5.00 |
8 | 2018-04-02 11:26:38 | NULL | 5.00 |
9 | 2018-04-03 12:22:31 | NULL | 5.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started