I would want to know, what can be improved.
Hi @sudarshanawasthi47 !
Thanks for sharing your project here. I just posted my own version of the CIA Factbook SQL project, and I was excited to see how other folks approached it. One of the first things that I noticed when I saw your project was that you use your headers to effectively organize your project. It makes it a lot easier to scan the entire document when there are those visual anchors.
I found it a bit more challenging to scan your code cells. I would encourage you to take a look at the SQL Style Guide, particularly the section on white space. They recommend that you organize the code not based on 4-space indents (like we do in python), but rather with right justification of each command For example:
def a_function(foo): for i in range(len(foo)): bar[i] = foo[i] + 2 return bar
SELECT foo, bar FROM data WHERE data > 0 ORDER BY bar
The style guide calls it a ‘river’ running down the center of your query, which makes it easy to ID commands at a glance.
Hopefully that is a helpful suggestion!