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:

1. Total population of India
2. Average growth by State and Average growth of India.(both in percentage)
3. Average sex ratio
4. Average literacy rate
5. Top 3 states with highest growth ratio
6. Bottom 3 states having lowest sex ratio
7. Top 3 and Bottom 3 states in literacy rate.
8. States starts with specific letters
9. No. of Males and Females out of total population
10. Statewise male count and female count
11. Statewise literate peoples and illiterate people
12. Statewise population of India in previous year
13. Population of India in previous year
14. Population vs Area
15. Top 3 districts from each state with highest literacy rate using rank

Thank You.☻