Database: warehouse_1
Question: Find the total value and number of boxes for each content type.
SQL:
SELECT sum(value) ,  count(*) ,  CONTENTS FROM boxes GROUP BY CONTENTS