A new table, reviews, holds product reviews. Its id is an identity column: the database chooses each new id.
Each task changes rows and shows the changed rows in the Result tab, with one statement. Do not run a separate SELECT.
- Add a 4-star review of product 2 with the text
Cute and big. The result shows only the new review'sid. - Which id did the database give it?
- Add 1.00 to the price of every Mug (
category_id4). The result shows each mug'sname, then its newprice. - Remove every 1-star review. The result shows every column of the reviews you removed.