SQL_IndianElectiondatabase/SQLQuery3.sql at main · rachanaudupa/SQL_IndianElectiondatabase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

SELECT

SUM (CASE

					When party IN ( 'Bharatiya Janata Party - BJP',
                'Telugu Desam - TDP',
				'Janata Dal  (United) - JD(U)',
                'Shiv Sena - SHS',
                'AJSU Party - AJSUP',
                'Apna Dal (Soneylal) - ADAL',
                'Asom Gana Parishad - AGP',
                'Hindustani Awam Morcha (Secular) - HAMS',
                'Janasena Party - JnP',
				'Janata Dal  (Secular) - JD(S)',
                'Lok Janshakti Party(Ram Vilas) - LJPRV',
                'Nationalist Congress Party - NCP',
                'Rashtriya Lok Dal - RLD',
                'Sikkim Krantikari Morcha - SKM')
				THEN [Won]
				ELSE 0
				END) AS NDA_Total_Seats

				FROM partywise_results