Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t1.province, t2.fullname,sum(t1.total_vote) AS total
- FROM votes AS t1, candidate AS t2
- WHERE t1.candidate_id = t2.id
- GROUP BY t2.id, t1.province
- ORDER BY t2.id
- SELECT concat(t2.fullname, ' has ', sum(t1.total_vote), ' votes in ', t1.province, '.') AS concatinated_line
- FROM votes AS t1
- INNER JOIN candidate AS t2 ON t1.candidate_id = t2.id
- GROUP BY t2.id, t1.province
- ORDER BY t2.id
- SELECT concat(t2.fullname, ' has ', sum(t1.total_vote), ' votes in ', t1.province, '.') AS concatinated_line
- FROM votes AS t1
- INNER JOIN candidate AS t2 ON t1.candidate_id = t2.id
- GROUP BY t2.id, t1.province
- ORDER BY t2.id
- SELECT fullname , GROUP_CONCAT(cast(total as char))
- FROM
- (
- SELECT t2.fullname fullname,sum(t1.total_vote) AS total
- FROM votes AS t1, candidate AS t2
- WHERE t1.candidate_id = t2.id
- GROUP BY t2.id, t1.province
- ORDER BY t2.id
- ) s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement