How many total songs has the order #1
CREATE TABLE table_21501518_1 (song_choice VARCHAR, order__number VARCHAR)
SELECT COUNT(song_choice) FROM table_21501518_1 WHERE order__number = "1"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_21501518_1 (song_choice VARCHAR, order__number VARCHAR) Question: How many total songs has the order #1 [/INST] SELECT COUNT(song_choice) FROM table_21501518_1 WHERE order__number = "1" </s>