Powerful SQL queries that you might not know

queries could exist in different dialects too but with different syntax, or not supported in some dialects at all. The problem with this method is that if you have a lot of categories for each brand, the number of rows will become so many that it’s difficult to inspect each brand. Using array_agg we can easily answer questions like ‘How many categories does each brand have?’.