Database: warehouse_1
Question: Find the average and maximum value for each different content.
SQL:
SELECT avg(value) ,  max(value) ,  CONTENTS FROM boxes GROUP BY CONTENTS