Thread: How to get the percentage??

Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT elec.sum ( votes ) as votes, stat.sum ( rating ) as rating, votes/rating as percentage FROM elec, stat WHERE YEAR = 2009 SELECT elec.sum(votes) as votes, stat.sum(rating) as rating, votes/rating as percentage FROM elec, stat WHERE YEAR=2009 Only thing I'm not sure about is the YEAR = 2009 in the where.

Following query should work I m assuming that both table contains year column Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT sum ( elec.votes ) /sum ( stat.rating ) as percentage FROM elec INNER JOIN on elec. YEAR =stat. YEAR WHERE stat. YEAR = 2009 select sum(elec.votes)/sum(stat.rating) as percentage from elec inner join on elec.year=stat.year where stat.year=2009

• • • • Originally Posted by urtrivedi Following query should work I m assuming that both table contains year column Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT sum ( elec.votes ) /sum ( stat.rating ) as percentage FROM elec INNER JOIN on elec. YEAR =stat. YEAR WHERE stat. YEAR = 2009 select sum(elec.votes)/sum(stat.rating) as percentage from elec inner join...