How many players named paddy rowan?
CREATE TABLE table_16527640_2 (rank_held_at_time_of_death VARCHAR, player VARCHAR)
SELECT COUNT(rank_held_at_time_of_death) FROM table_16527640_2 WHERE player = "Paddy Rowan"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_16527640_2 (rank_held_at_time_of_death VARCHAR, player VARCHAR) Question: How many players named paddy rowan? [/INST] SELECT COUNT(rank_held_at_time_of_death) FROM table_16527640_2 WHERE player = "Paddy Rowan" </s>