Challenge: BigQuery SQL

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: