Task: Text to Code
Input (English): Step 1: For each row in Products table, find the corresponding rows in Product_Characteristics table.
Step 2: find product_name of the results of step 1 whose product_characteristic_value equals Handful.
Step 3: For each row in Product_Characteristics table, find corresponding rows in Characteristics table and in Products table.
Step 4: find product_name of the results of step 3 whose characteristic_data_type equals white.
Step 5: show the rows that are in the results of step 2 but not in the results of step 4
Output (English): SELECT T1.product_name FROM Products AS T1 JOIN Product_Characteristics AS T2 ON T1.product_id = T2.product_id WHERE T2.product_characteristic_value = "Handful" EXCEPT SELECT T1.product_name FROM Characteristics AS T3 JOIN Products AS T1 JOIN Product_Characteristics AS T2 ON T3.characteristic_id = T2.characteristic_id AND T2.product_id = T1.product_id WHERE T3.characteristic_data_type = "white"