What is the name of the artist who produced the shortest song?
CREATE TABLE files (f_id VARCHAR, duration VARCHAR); CREATE TABLE song (artist_name VARCHAR, f_id VARCHAR)
SELECT TOP 1 T1.artist_name FROM song AS T1 JOIN files AS T2 ON T1.f_id = T2.f_id ORDER BY T2.duration
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE files (f_id VARCHAR, duration VARCHAR); CREATE TABLE song (artist_name VARCHAR, f_id VARCHAR) Question: What is the name of the artist who produced the shortest song? [/INST] SELECT TOP 1 T1.artist_name FROM song AS T1 JOIN files AS T2 ON T1.f_id = T2.f_id ORDER BY T2.duration </s>