Fill in the order form to get the price

SQL Group By

A sql-6-9.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):

Use the e_store database

Join the products and the reviews tables that would output this:

----+------------+-----------+

| id | name | avg_stars |

+----+------------+-----------+

| 2 | Smartphone | 2.3333 |

| 3 | PC | 3.0000 |

+----+------------+-----------+

2 rows in set (0.01 sec)