Where Turns It Inner

authors:

id	name
1	Ada
2	Bo
3	Cy

books:

id	author_id	year
10	1	2019
11	1	2023
12	2	2018

SELECT a.name, count(b.id) AS n
FROM authors a
LEFT JOIN books b ON b.author_id = a.id
WHERE b.year >= 2019
GROUP BY a.name
ORDER BY a.name;

What comes back?