Texas new COVID cases IV.
And the results are:
Good news, seems to be still dropping more and more.
Transactions by browser in July 2017
Analytics sample in BQ
SELECTdevice.browser,SUM ( totals.transactions ) AS total_transactionsFROM `bigquery-public-data.google_analytics_sample.ga_sessions_*`WHERE_TABLE_SUFFIX BETWEEN '20170701' AND '20170731'GROUP BY device.browserHAVING SUM ( totals.transactions ) > 0 ORDER BYtotal_transactions DESC
public SQL Analytics Bigquery TABLE SUFFIX
What tables do I have in this dataset in BQ?
List them!
More tables, like with Google Analytics:
Get latest (freshest date/table)
It is so META good.
SELECT max(table_id) as latest_available_day_tbl FROM `bigquery-public-data.google_analytics_sample.__TABLES_SUMMARY__`