USING SQL Database Development This question is worth 25 points. Please use our

Question

USING 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) The order ID must be within the range of 10200 and 10500

2)      The order date must be from the month of July

3)      The employee last name must be Peacock

Explanation / Answer

1) select company_name,address,city,region,employee_lastname,order_ID,order_date

  from CUSTOMER

  where order_ID between 10200 and 10500;

2) select company_name,address,city,region,employee_lastname,order_ID,order_date

  from CUSTOMER

   where order_date >= 'July';

3)   select company_name,address,city,region,employee_lastname,order_ID,order_date

  from CUSTOMER

   where employee_last_name = 'Peacock';

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.