You are leveraging the free integration feature between Firebase Analytics and Google BigQuery to monitor app events. This integration results in the automatic creation of new tables each day in BigQuery, with the naming format app_events_YYYYMMDD. Suppose you want to analyze data spanning the last 30 days. How would you query all of these daily tables from the past month using legacy SQL?