Question: SQL Database Book insert Bookorama This assignment is based on the books database built by BookORama Example. Write SQL statements in MySQL Workbrench to make
SQL Database

Book insert

Bookorama

This assignment is based on the books database built by BookORama Example. Write SQL statements in MySQL Workbrench to make the following queries: 1. Find the number of orders made by customer id of 3. 2. List customer name and city sorted by city in descending order. 3. List all orders made by customer Michelle Arthur 4. List all books ordered by customer Michelle Arthur. (You are not allowed to use any previous query results to make this query.) 5. List all customer names who bought any Java related books. You need to submit all your SQL statements in a sql file like the example file 'assignment3 Mourfirstname Jastname sgl", which has three example questions (the assignment has 5 questions). You also need to test your SQL statements and submit screenshot(s) to show your test is successful. Please put all the screenshot results in a word file with the name as nment r firstname lastname docx Note: For the SQL code that you do not need and do not want to delete, or the comments in .sql file, you comment them out through using commands: this is a comment this is also a comment Or a multi-line comment multiline comment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
