Question: please do all parts for a thumbs up Instructions This assignment is based on W3School database. You have two options: 1. You can download the

please do all parts for a thumbs up
please do all parts for a thumbs up Instructions This assignment is
based on W3School database. You have two options: 1. You can download

Instructions This assignment is based on W3School database. You have two options: 1. You can download the database (w3school.sql file) and run it on workbench. Hoe to Open SQL files in MySQL Workbench: If you are using MySQL workbench on your computer, first download the W3Schools.SQL file and then open the fle in MySQL Workbench, to open it in MySQL workbench click on Fle. Open SQL Script and select the file. 2. If you don't have MySQL. Workbench on your computen: Use https:/lwww.w3schools.com/sqlitrysq iasp?filename=trysql select all here you have access to all content of the database. On this website, you can write your SQL statements and then copy each command to a , txt file. Please turn in only one SQL file (or a bt fle) and submit it to the Assignment Submission Folder assigned for the homework. Answer the following questions. Make sure you use comments in yout SQL file to clarityishow which SQL statement is the answer to which question. The questions are: Write an SQL query to show the CustomerName and Country of Customers. Write an SQL query to show all Countries (no duplicates), order them alphabetically. Write an SQL query to show the first name of all employees ordered by their last name in alphabetic order. Write an SQL query to show the detail of all shippers. Write an SQL query to show the top five expensive products. Write an SQL query to show all details of suppliers, only show five of them. Write an SQL query to show all details of Categories. Write an SQL query to show all details of Orders, show the recent ones on the top. Write an SQL query to show product names, their units, and their prices. - Write an SQL query to show all details of orders (from OrderDetails table). W3Schools.sql (41.39 KB)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!