Review Request of Project: Analyzing CIA Factbook Data Using SQL

  • notebook (.ipynb file) --> Link
    Sharing my Project on Analyzing CIA Factbook Data Using SQL.
    Kindly review the project.
    Your feedback will help me to improve.

hi @jainanu827

Thanks for sharing your project with DQ Community!

The sections before each query help in identifying what the query is about, specifically putting down the conditions. :+1: You have mentioned the answer section for the water to land ratio query.

But why not have a consistent answer cell as well, just one-liners for the results such as -

“Avg Population of the data set is : n”

Also, why not utilize the power of sub-queries for Pop and Area Avg? The hard coded values may change if we change/update the dataset.

1 Like