Derive Insights from BigQuery Data: Challenge Lab Reviews

rahmat h. · Reviewed over 1 year ago

Rania H. · Reviewed over 1 year ago

Anitha T. · Reviewed over 1 year ago

Bhargavi B. · Reviewed over 1 year ago

Vijay G. · Reviewed over 1 year ago

jorgeleickoliveira G. · Reviewed over 1 year ago

gabriel b. · Reviewed over 1 year ago

Vinayak J. · Reviewed over 1 year ago

Gustavo V. · Reviewed over 1 year ago

Norbert D. · Reviewed over 1 year ago

Mark A. · Reviewed over 1 year ago

great

Gaurav S. · Reviewed over 1 year ago

Gadi B. · Reviewed over 1 year ago

Himanshi K. · Reviewed over 1 year ago

x

M C. · Reviewed over 1 year ago

Priyanshu T. · Reviewed over 1 year ago

Detlev M. · Reviewed over 1 year ago

Sudarkodi M. · Reviewed over 1 year ago

Tanishka B. · Reviewed over 1 year ago

Rutika G. · Reviewed over 1 year ago

ARVAPALLI B. · Reviewed over 1 year ago

APEKSHA U. · Reviewed over 1 year ago

Sachin S. · Reviewed over 1 year ago

Glenn W. · Reviewed over 1 year 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 over 1 year ago