Database: warehouse_1
Question: For each content, what is the total value and number of boxes?
SQL:
SELECT sum(value) ,  count(*) ,  CONTENTS FROM boxes GROUP BY CONTENTS