代做MIS 385 SQL Queries Assignment调试SQL 程序

MIS 385

SQL Queries Assignment

Submission instructions

What to submit:

· One PDF file with the SQL queries code.

Questions

Download bookstoreHW.sql (do not edit this file). This is the same database of Exercise 4, but now in MySQL workbench. 

Start by importing the database to MySQL Workbench (make sure to follow exactly the instructions on how to import/export databases in MySQL workbench). Then, create the entity-relationship of the database and export it to a pdf. It is important to have the diagram handy when creating the queries.

Now, create a SQL query for each of the questions below. First, run the code on My SQL Workbench, then copy the code to a Word file, and finally, after you have all codes, convert the Word file to a PDF and submit it.

Note: Assign aliases in the queries whenever necessary (please use a short name that briefly describes the information on the corresponding column).

1. For each order, list the order_numb, order_date, credit_card_numb, the corresponding customer first and last names, and customer phone.

2. Repeat query 1, but only showing orders that have been filled and that were placed before March 1, 2016.  

3. Show all book titles ordered before March 1, 2016.  Do not list any title more than once.

4. For each book, show the isbn, author, title, and quantity sold. Sort the books by quantity sold from largest to smallest. The number of books column should have the heading "units_sold".

5. Find out the total number of orders that have not been shipped.