Find the youngest customer grouped by province

0 votes

1 answer

252 views

SELECT a.province, c.birth_date, c.name 
FROM customer c
JOIN address a ON (c.cust_id = a.cust_id) 
GROUP BY a.province 
ORDER BY birth_date DESC;

I want to find the youngest customer in each province. The query above doesn't work.

Asked by Omar Hassan (11 rep)

Mar 2, 2022, 07:16 AM
Last activity: May 23, 2025, 05:04 PM