SQL practice: Arrays: Many Values in One Cell

For each product category, collect the product names into an array called products, sorted alphabetically inside the array. Show category too, ordered by category.

Turn the list North, South, East, West into four rows, in a column named region. Do not create a table.

For each category show the category and how many products it has, using an array function rather than COUNT. Name the count how_many, ordered by category.

List the branch_name of every branch in the North or South region, using = ANY against an array rather than IN. Order by branch_name.

Show each region alongside a comma-and-space separated list of its cities, in a column named cities, sorted inside the list. Order by region.

Split the string 'North,South,East' on commas and return one row per piece, in a column named region. Order by region.

Find every branch whose region array — built as a one-element array from its region column — overlaps with North or East. Show branch_name and region, ordered by branch_name.

You have a table with a tags text[] column and you need to find rows tagged both "urgent" and "export". Which operator does that?