MySQL

Group By - Having

A sql-6-12.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 - Join the products and the reviews in a SELECT query that would output this:

+------------+--------+-------+-----------+ | name | price | stock | avg_stars | +------------+--------+-------+-----------+ | Tablet | 145.50 | 8 | 4.0000 | | Headphones | 20.00 | 6 | 3.5000 | | Monitor | 125.45 | 7 | 5.0000 | +------------+--------+-------+-----------+ 3 rows in set (0.01 sec)