SELECT * FROM tab_name WHERE col1 = N ORDER BY col2 [DESC]

SELECT id, count(*) as count FROM tab_name GROUP BY id