Which attribute definitions have attribute value 0? Give me the attribute name and attribute ID.
SELECT t1.attribute_name ,  t1.attribute_id FROM Attribute_Definitions AS t1 JOIN Catalog_Contents_Additional_Attributes AS t2 ON t1.attribute_id  =  t2.attribute_id WHERE t2.attribute_value  =  0
attribute definitions with attribute value 0 refers to WHERE t2.attribute_value = 0; attribute name and attribute ID refers to SELECT t1.attribute_name, t1.attribute_id;