Answer to Question #69047 in Databases | SQL | Oracle | MS Access for Daniel Cervantes

Question

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)

Answer 1

Dear Daniel Cervantes, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order