GA4 writes a new table every day, so a two-week question means fourteen tables. A wildcard table queries them all at once: end the name with *, inside backticks.
SELECT event_name, COUNT(*)
FROM `lumen-coffee.analytics_301245.events_*`
WHERE _TABLE_SUFFIX BETWEEN '20250601' AND '20250607'
GROUP BY event_name;
_TABLE_SUFFIX is a pseudo column holding the part of each table name that the * matched, here the date as text. Filtering on it means BigQuery only reads those tables, so watch the estimate fall as you narrow the range. A filter on event_date instead returns the same rows but still reads every table.
The suffix is text, so compare it with text, and PARSE_DATE('%Y%m%d', _TABLE_SUFFIX) turns it into a date when you need one.