How many songs have a shared vocal?
CREATE TABLE vocals (songid VARCHAR); CREATE TABLE songs (songid VARCHAR)
SELECT COUNT(DISTINCT title) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid WHERE TYPE = "shared"
<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: How many songs have a shared vocal? [/INST] SELECT COUNT(DISTINCT title) FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid WHERE TYPE = "shared" </s>