Unrecognized dataset name or table not found

I keep getting error messages in BigQuery while working through the Google Data Analytics certificate.

I guess this is how you write legacy SQL and use in the place of ``

That might be the issue here.