Derive Insights from BigQuery Data: Challenge Lab Reviews

APEKSHA U. · Reviewed أكثر من سنة ago

Sachin S. · Reviewed أكثر من سنة ago

Glenn W. · Reviewed أكثر من سنة ago

The worst of all ... as if the system only understands specific SQL statements yet querying SQL statements can be of different ways but getting the same output.But this one here, ......!!! like all these codes get the same result 1. SELECT total_cases_worldwide FROM ( SELECT SUM(cumulative_confirmed) AS total_cases_worldwide FROM `bigquery-public-data.covid19_open_data.covid19_open_data` WHERE date = '2020-05-25' ) AS subquery; 2.SELECT SUM(cumulative_confirmed) AS total_cases_worldwide FROM `bigquery-public-data.covid19_open_data.covid19_open_data` GROUP BY date HAVING date = '2020-05-25'; 3.WITH cases_on_date AS ( SELECT cumulative_confirmed FROM `bigquery-public-data.covid19_open_data.covid19_open_data` WHERE date = '2020-05-25' ) SELECT SUM(cumulative_confirmed) AS total_cases_worldwide FROM cases_on_date; " All those upon a research i did, gives the same result but the system here is Nagging. I tried and tried and tried not giving up because of the time i have spent learning but, the output is .............

JEREMIAH JOSEPH O. · Reviewed أكثر من سنة ago

Vinoth A. · Reviewed أكثر من سنة ago

The time is a bit shorter for begineers. If possible, increase it to 2 hrs. I was trying to build everything without copying but could not finish the last question.

John T. · Reviewed أكثر من سنة ago

Nicholas A. · Reviewed أكثر من سنة ago

Mohammad S. · Reviewed أكثر من سنة ago

For the Looker studio assignment, instructions should be more clear

Parth V. · Reviewed أكثر من سنة ago

My last attempt was not marked as green.

Olena V. · Reviewed أكثر من سنة ago

Olena V. · Reviewed أكثر من سنة ago

Marinela P. · Reviewed أكثر من سنة ago

Abhijeet k. · Reviewed أكثر من سنة ago

Khushi K. · Reviewed أكثر من سنة ago

Alex O. · Reviewed أكثر من سنة ago

HERNAN A. · Reviewed أكثر من سنة ago

Vaibhavi P. · Reviewed أكثر من سنة ago

Mandeep K. · Reviewed أكثر من سنة ago

SAYAN G. · Reviewed أكثر من سنة ago

Sriramkrishna . · Reviewed أكثر من سنة ago

section 10 bugged out and would not let me complete. Had to use the "Explore in Looker Studio" option in BQ. waste of my time

Ellie H. · Reviewed أكثر من سنة ago

Dan R. · Reviewed أكثر من سنة ago

Vanshika J. · Reviewed أكثر من سنة ago

ANUSHKA B. · Reviewed أكثر من سنة ago

Bilal B. · Reviewed أكثر من سنة ago