[solved] – Question 69047
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)
Expert Answer
OR
