PROJECT_SQL

Data Analysis using SQL

Analysis on Indian Census Data 2011.

Data collected from:

○ https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqblRYMldKX1RCVkxlcWJQc1ctVktyNDBKZHpPUXxBQ3Jtc0trX0dseERhcEt4ODF1THFiWG5pQ21yY3Z2RG56TkIybm9qbTYzTm5TMEk0X3BQNWRiQnZsOWN2TXNyWHN6RzJ4b1dUb1Z3RVFNcmVUNXdUUVFFY1FvQ1p0dVNGZHVISllveTdsZ2M5cllwZEt2bTRFMA&q=https%3A%2F%2Fwww.census2011.co.in%2Fdistrict.php&v=I3YvjFfn478

○ https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqazlXaWZhMDVUZGdaUVJ5c1NTaGVZaWg3SEc5Z3xBQ3Jtc0trTXRYVWdncy1zR1JIOEFhZnpDU0dReTNfaFZPS1ByX1g0WTRtSVZDWjgySjloNGVwLVV6bXM4bGlHck9BZS10YWNoVzIwY0RFbk1FWk9QYmd5RC0tUmxYRm1EbGlIVzI3djZrU0t6NGZUMXFSQndwVQ&q=https%3A%2F%2Fwww.census2011.co.in%2Fliteracy.php&v=I3YvjFfn478

Steps that I have done in this analysis are:

Total population of India
Average growth by State and Average growth of India.(both in percentage)
Average sex ratio
Average literacy rate
Top 3 states with highest growth ratio
Bottom 3 states having lowest sex ratio
Top 3 and Bottom 3 states in literacy rate.
States starts with specific letters
No. of Males and Females out of total population
Statewise male count and female count
Statewise literate peoples and illiterate people
Statewise population of India in previous year
Population of India in previous year
Population vs Area
Top 3 districts from each state with highest literacy rate using rank

Thank You.☻