LTM Limited interview question

Syntax Difference of SQL and BigQuery SQL