Programming Homework Help. Rutgers University SQL Codes Project
I’m working on a mysql exercise and need an explanation and answer to help me learn.
Files to submit:
You need to submit one pdf file with:
- names of the members of the group;
- the SQL codes of all questions in PDF format.
Questions:
In this homework you will be using the same bookstore database as in the previous homework.
Create a MySQL query for each of the cases below. First run the code on MySQL Workbench, then copy the code to a Word file, and finnaly after you have all codes, convert the Word file to a PDF and submit it.
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.
