Task: Text to Code
Input (English): Step 1: For each row in Ref_Characteristic_Types table, find the corresponding rows in Characteristics table.
Step 2: find characteristic_name, other_characteristic_details, characteristic_type_description of the results of step 1.
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 T2.characteristic_name , T2.other_characteristic_details , T1.characteristic_type_description FROM Ref_Characteristic_Types AS T1 JOIN Characteristics AS T2 ON T1.characteristic_type_code = T2.characteristic_type_code EXCEPT SELECT T2.characteristic_name , T2.other_characteristic_details , T2.characteristic_data_type FROM Characteristics AS T2