I'm trying to automate a lookup on a table based on the current year, after some help as this doesn't seem to work. I want the year appended to the table name
example: FROM t_refuse_garden_2019
SELECT count(green_uprn) AS a
WHERE green_uprn = '12345678'
AND green_end_date is null