@harshkaushik4634

i am learinng DA skills, and this elections project is one i had in my mind that after learning all necessary skills, i will make a project on elections result but i didn't get data on govt_data portal and on kaggle as well or maybe i am too noob to find it. But now seeing this project its like dream come true. I honestly thank and with whole heart appriciate you who are giving the weak people a chance to learn these skills and earn bread. I really appricate your effort and hardwork. I am finding difficulty in cleaning the data.

@pushkarthorat007

This type of video is what we exactly need.
Please keep making such videos. Thank you!

@rahulkumarkatari3044

The Project is very Awesome and its my first my SQL Project

@pavanr6100

Absolutely Loved it Sir, now my confidence is at the peak to gear up for any SQL interviews. 
kindly replicate the same and showcase your charisma of analysis via power bi 
🙏🙏🙏🙏

@mrbartuss1

51:40
Instead of SELECT DISTINCT (COUNT ..., SELECT COUNT(DISTINCT ... should be used. Since COUNT() returns a single integer, the DISTINCT clause has no practical effect
This statement first counts the occurrences of a specified column and then returns distinct counts of those results. However, it is important to note that this usage is not common and can lead to confusion. The DISTINCT keyword here applies to the result of the COUNT() function, which typically returns a single value (the total count). Thus, the DISTINCT keyword effectively does not change the output because the count itself will only yield one row

@Rohit.07rd

Thanks for this sql project it really helped me a lot im understanding the concepts properly

@manuelmelendezebrat165

Hi, fixed. great video. Honestly your tutorials are the best

@karma1185

Im trying to learn Data Analytics and i can say i started at right place. Thanks

@karthikbala8474

Please do powerbi project on election dashboard also

@Be-PositiveEnjoy-Life

I saw whole video its just awesome!! You are doing great! 

Just 1 request from me can you create a dashboard on this project using power bi/tableau it will help me to get understand more better

Happy to say I am your new subscriber!😊

@ShaikhAlyna-fw3op

I really appreciate your efforts 🙏🏻 Thank you sir

@Anushannn

you are a SAVIOUR 🙌🙌🙌Bro

@Ian15278

This type of video is what we exactly need.
Please keep making such videos. Thank you!

--What is the total number of Seats available for elections in each state?
select s.state, COUNT(sw.constituency) as total_seat
from states s
inner join statewise_results sw on 
s.State_ID = sw.State_ID
group by s.State
order by COUNT(sw.constituency) desc;

@enakalluprasad1359

You are the best brother❤

@allaboutpriya1996

Thank you #Datatutorials... 
🙏🏻🙏🏻

@MrWayra11

Thank you !

@DataAnalystkenya

Hello, Thanks for this

@sanfologieabdoulaziz2908

Great video

@rajafhazmah2525

thanks you sirr

@nikhilraj71

if statewise data sheet not importing check row 49 of the sheet trailing candidate