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

Question

Use the e_store database
Get the average rating of product_id 4. Alias the average result as: avg_rating.
The result should look like this:
+----+------------+
| id | avg_rating |
+----+------------+
| 4 | 3.5000 |
+----+------------+
1 row in set (0.08 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