How many 'Cutlery' type products are there?
select count ( product_id ) from products_for_hire where product_type_code = 'Cutlery'
Okay good to know. How many products have a daily hire cost lower than 20?
select count ( product_id ) from products_for_hire where daily_hire_cost < 20
Thank you for that info. Now, how many 'cutlery' products have the daily hire cost lower than 20?
select count ( product_id ) from products_for_hire where product_type_code = 'Cutlery' and daily_hire_cost < 20