Return the gender and name of artist who produced the song with the lowest resolution.
CREATE TABLE artist (gender VARCHAR, artist_name VARCHAR); CREATE TABLE song (artist_name VARCHAR, resolution VARCHAR)
SELECT TOP 1 T1.gender, T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name ORDER BY T2.resolution
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE artist (gender VARCHAR, artist_name VARCHAR); CREATE TABLE song (artist_name VARCHAR, resolution VARCHAR) Question: Return the gender and name of artist who produced the song with the lowest resolution. [/INST] SELECT TOP 1 T1.gender, T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name ORDER BY T2.resolution </s>