Meta Interview Question

filters, joins, case statements, counts, aggregations