副問い合わせメモ【SQL】

SELECT name AS player, (SELECT count(*) FROM votes WHERE votes.voted_id=membs.id) AS score FROM membs ORDER BY score DESC;

+-------------+-------+
| player      | score |
+-------------+-------+
| name0さん   |     5 |
| name2さん   |     5 |
| name4さん   |     5 |
| name5さん   |     4 |
| name6さん   |     4 |
| name7さん   |     4 |
| name8さん   |     4 |
| name1さん   |     3 |
| name3さん   |     3 |
| name9さん   |     0 |
+-------------+-------+
10 rows in set (0.00 sec)