ค้นหาชื่อผลิตภัณฑ์ที่มีสี 'สีขาว' แต่ไม่มีหน่วยวัด "Handful" ไม่จำเป็นต้องใช้ตารางทั้งหมด
Find the product names that are colored 'white' but do not have unit of measurement "Handful".It is not neccessary to use all the tables.
 products:  (product_name [ VARCHAR ] product_category_code [ VARCHAR ] color_code [ VARCHAR) ]
SELECT t1.product_name FROM products AS t1 JOIN ref_product_categories AS t2 ON t1.product_category_code = t2.product_category_code JOIN ref_colors AS t3 ON t1.color_code = t3.color_code WHERE t3.color_description = "white" AND t2.unit_of_measure <> "Handful"