Table: artist_discography
Columns: year
artist
title
label
type

Question: which Type has a Title of so alive?
SQL: SELECT "type" FROM artist_discography WHERE "title" = 'so alive'

Question: Name the Year which has a Label of atco records and a Type of album? Question 2
SQL: SELECT "year" FROM artist_discography WHERE "label" = 'atco records' AND "type" = 'album'

Question: Which Title has a Type of album and a Year larger than 1986?
SQL: SELECT "title" FROM artist_discography WHERE "type" = 'album' AND "year" > 1986

Question: Which Title has a Type of ep and a Year larger than 2003?
SQL: SELECT "title" FROM artist_discography WHERE "type" = 'ep' AND "year" > 2003

Question: Which Title has a Type of album in 1983?
SQL: SELECT "title" FROM artist_discography WHERE "type" = 'album' AND "year" = 1983