Challenge: BigQuery SQL
Test our BigQuery SQL skills.
We'll cover the following
Problem statement
In this challenge, we will design a BigQuery table that generates monthly financial reports. The steps include creating source tables, inserting data, transforming data, and writing the results into the final table.
Note: We need to enable billing for the GCP project because of DML queries that we will run in this challenge. Please refer to Appendix for instructions on enabling billing in the GCP project.
Create source tables
Create the following three source tables in the sql_challenge
dataset. Here is the table schema:
Get hands-on with 1200+ tech skills courses.