Database: warehouse_1
Question: Find the number of distinct types of contents in each warehouse.
SQL:
SELECT count(DISTINCT CONTENTS) ,  warehouse FROM boxes GROUP BY warehouse