CREATE TABLE table_16527640_2 (rank_held_at_time_of_death VARCHAR, player VARCHAR)

How many players named paddy rowan?
SELECT COUNT(rank_held_at_time_of_death) FROM table_16527640_2 WHERE player = "Paddy Rowan"
SELECT COUNT("rank_held_at_time_of_death") FROM "table_16527640_2" WHERE "Paddy Rowan" = "player"