How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask TheDoctor Your Own Question
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1757
Experience:  M.S. in Internet Information Systems
59032869
Type Your Homework Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

1. Using the Logical operators: AND, OR, write a query that

Resolved Question:

1. Using the Logical operators: AND, OR, write a query that returns the orders placed in July 1996 by Nancy Davolio, Janet Leverling, and Steven Buchanan. List the order ID, employee ID, and the order date. Order the result set by the employee ID

2. Write a query that returns the three ship countries with the highest average freight in 1996. List the country and the average freight.

3. Write a sub-query that returns all orders placed on the last day of activity that can be found in the Orders table. Include the order ID, order date, customer ID, and the employee ID.

4. Write a sub-query that returns the number of orders by the customer with the highest number of orders. Include Customer ID and the number of orders placed.

5. Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include employee ID, last and first names.

6. Create a VIEW that returns the total number of daily orders placed in July 1996 Display the Number of Orders and the order date.

7. Use a Sub-query and Logical operators: AND, OR Create a View that return the orders placed in July 1996 by Nancy Davolio, Janet Leverling, and Steven Buchanan. List the order ID, employee ID, and the order date.

8. Create a View that returns all employees with last name containing the letter 'a' twice or more. Display the employee ID, first and last names

Submitted: 3 years ago.
Category: Homework
Expert:  TheDoctor replied 3 years ago.
Hello and thank you for your question.
Please provide the database details, including the SQL to create and populate the database. This should be available to you as part of the course.
Let me know what DBMS is being used (i.e., Oracle, MySQL, or SQL Server). Zip up the SQL file and upload the zip file to http://ge.tt
Once uploaded, you will be given a link on the right. Click on the 'Copy Link' option and then paste it here.
Thank you
Customer: replied 3 years ago.

Northwind database, SQL2012 Express

Expert:  TheDoctor replied 3 years ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Customer: replied 3 years ago.

Thanks they worked great.

Expert:  TheDoctor replied 3 years ago.
You are very welcome. Have a wonderful night!

Related Homework Questions