Views
Instruction
That's correct. Ok, looks like you know how views work. Let's make a quick revision.
Exercise
In the table product, there are the following columns: id, name, category, price.
Create a view called tablet which will select all columns for only those products which belong to the category tablet.
Stuck? Here's a hint!
Type
CREATE VIEW tablet AS SELECT * FROM product WHERE category = 'tablet';
