More summaries: STRING_AGG, FILTER and ROLLUP · exercise 1 of 1 · free preview
STRING_AGG(column, ', ') joins the values of each group into one text. Add ORDER BY inside the brackets to control the order. It works like TEXTJOIN in Excel.
For every city, show the city and names: the first names of its customers, sorted alphabetically and separated by a comma and a space. Order by city.
Tables in this practice shop
customersproductsordersorder_items