Paulo R. Rodegheri Brasil
The sales industry needs a report to know what products are left in stock.
To help the sales industry, display the product name and category name for products whose amount is greater than 100 and the category ID is 1,2,3,6 or 9. Show the results in ascendent order by category ID.
Column | Type |
id (PK) | numeric |
name | character varying (255) |
amount | numeric |
price | numeric |
id_categories (FK) | numeric |
Column | Type |
id (PK) | numeric |
name | character varying (255) |
id | name | amount | price | id_categories |
1 | Blue Chair | 30 | 300.00 | 9 |
2 | Red Chair | 200 | 2150.00 | 2 |
3 | Disney Wardrobe | 400 | 829.50 | 4 |
4 | Blue Toaster | 20 | 9.90 | 3 |
5 | Solar Panel | 30 | 3000.25 | 4 |
id | name |
1 | Superior |
2 | Super Luxury |
3 | Modern |
4 | Nerd |
5 | Infantile |
6 | Robust |
9 | Wood |
name | name |
Red Chair | Super Luxury |