Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. SELECT t1.province, t2.fullname,sum(t1.total_vote) AS total
  2. FROM votes AS t1, candidate AS t2
  3. WHERE t1.candidate_id = t2.id
  4. GROUP BY t2.id, t1.province
  5. ORDER BY t2.id
  6.  
  7. SELECT concat(t2.fullname, ' has ', sum(t1.total_vote), ' votes in ', t1.province, '.') AS concatinated_line
  8. FROM votes AS t1
  9. INNER JOIN candidate AS t2 ON t1.candidate_id = t2.id
  10. GROUP BY t2.id, t1.province
  11. ORDER BY t2.id
  12.  
  13. SELECT concat(t2.fullname, ' has ', sum(t1.total_vote), ' votes in ', t1.province, '.') AS concatinated_line
  14. FROM votes AS t1
  15. INNER JOIN candidate AS t2 ON t1.candidate_id = t2.id
  16. GROUP BY t2.id, t1.province
  17. ORDER BY t2.id
  18.  
  19. SELECT fullname , GROUP_CONCAT(cast(total as char))
  20. FROM
  21. (
  22. SELECT t2.fullname fullname,sum(t1.total_vote) AS total
  23. FROM votes AS t1, candidate AS t2
  24. WHERE t1.candidate_id = t2.id
  25. GROUP BY t2.id, t1.province
  26. ORDER BY t2.id
  27. ) s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement