Which vocal type has the band mate with first name "Marianne" played the most?
CREATE TABLE vocals (bandmate VARCHAR); CREATE TABLE band (id VARCHAR)
SELECT TOP 1 TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate = T2.id WHERE firstname = "Marianne" GROUP BY TYPE ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE vocals (bandmate VARCHAR); CREATE TABLE band (id VARCHAR) Question: Which vocal type has the band mate with first name "Marianne" played the most? [/INST] SELECT TOP 1 TYPE FROM vocals AS T1 JOIN band AS T2 ON T1.bandmate = T2.id WHERE firstname = "Marianne" GROUP BY TYPE ORDER BY COUNT(*) DESC </s>