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