SQL Code

Working with multiple tables

• TemporaryTable: Example about using temporary table in BigQuery
• InnerJoins: Example about using INNER JOIN in BigQuery

Useful Example

• SecondHighestNumber: How to report the second highest salary
• TreeNode: How to find the node type of Binary Tree in MySQL
• RankScore: How to use DENSE_RANK() to rank the scores in MySQL
• PivotTable: How to create a Pivot Table in MySQL