Question: Below is a database for a supplier that works with clothing retail businesses. Review the structure of the eight tables ( Employees , Offices, Customers,

Below is a database for a supplier that works with clothing retail businesses. Review the structure of the eight tables (Employees, Offices, Customers, Products, Product Lines, Order Details, Orders, and Payments). In the text box below, type the five SQL statements that answer the following statements. Label each statement with the appropriate statement number below so they are graded correctly.
Statement 1: Write the SQL statement to show all order numbers and their status for orders placed in May 2023.
Statement 2: Write the SQL statement to show customer numbers, last names, and states where customers reside that live in Delaware ("DE") or Pennsylvania ("PA").

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!