Refreshers on pure SQL

These questions test your core SQL that will be required before attempting the window function questions

You will require group by, array_agg and filter If you are already comfortable with these then feel free to skip ahead

All questions are based around a table containing imaginary cats.