Start the Reviews Over
MediumDescription
Reviews are being reset for a relaunch. Remove every review so that the next review
gets review_id 1, then add these two reviews in one INSERT:
| product_id | customer_id | rating | comment |
|---|---|---|---|
| 31 | 26 | 5 | Bright and smart. |
| 12 | 27 | 4 | Cooks fast. |
Then show review_id, product_id, customer_id and rating of every review.
End your query with ORDER BY review_id.
Tables
| reviews |
|---|
| review_id (PK) |
| product_id (FK) |
| customer_id (FK) |
| rating |
| comment |
| created_at |