Question: USEING SQL Database Development. This question is worth 25 points. Please use our cissql server, and the Northwind database Please make sure you have the

USEING SQL Database Development.

This question is worth 25 points.

Please use our cissql server, and the Northwind database

Please make sure you have the following within your query

1. The use statement with the database being used

2. Comment with your name, quiz and query number.

Query: Display the customers company name, address, city, region, employee last name, order ID and the order date for orders that meet the following criteria:

1) Use a sub-query to get the order ID, which must be within the range of 10200 and 10500.

2) The order date must be from the month of July, ( irregardless of the year).

3) The employee last name must be Peacock

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!