Database: product_catalog
Question: Which attribute definitions have attribute value 0? Give me the attribute name and attribute ID.
SQL:
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