Which song has the most vocals?
CREATE TABLE vocals (songid VARCHAR); CREATE TABLE songs (songid VARCHAR)
SELECT TOP 1 title FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid GROUP BY T1.songid ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE vocals (songid VARCHAR); CREATE TABLE songs (songid VARCHAR) Question: Which song has the most vocals? [/INST] SELECT TOP 1 title FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid GROUP BY T1.songid ORDER BY COUNT(*) DESC </s>