MySQL Sample

1- Go to the following link

2 – Read the web page and click on download the MySQL Sample Database button

3- Extract the downloaded folder

4- Open MySQL Workbench and run the SQL script from the extracted folder

5- A schema called classic models should appear in the left panel of MySQL workbench

6- Study the tables and answer the following queries using SQL statments:

A- Who is the highest spending customer?

B- What is the total amount of revenue in 2003?

C- Who is the president of the company?

D- What is the QUESTION of the product that sold most in 2003?

What to turn in:

1- A SQL file with SQL statements answering the four queries