MySQL

SQL JOIN

A sql-6-4.sql file has been opened for you.

Write each of the following tasks as a SQL statement in a new line (remember that you can source the file to compare the output reference):

1- Use the e_store database

2 - Write a SELECT - JOIN query that displays the following table:

+----+--------------+--------+-------+ | id | product_name | price | stars | +----+--------------+--------+-------+ | 3 | PC | 157.40 | 3 | | 4 | Headphones | 20.00 | 2 | | 4 | Headphones | 20.00 | 5 | +----+--------------+--------+-------+ 3 rows in set (0.02 sec)