How many products are never booked with amount higher than 200?
SELECT count(*) FROM Products_for_hire WHERE product_id NOT IN ( SELECT product_id FROM products_booked WHERE booked_amount  >  200 )
never booked with amount higher than 200 refers to selecting product_id from a subquery with condition booked_amount > 200 and using NOT IN; count products refers to COUNT(*);