CREATE TABLE albums (aid DECIMAL, title TEXT, year DECIMAL, label TEXT, type TEXT)
CREATE TABLE performance (songid DECIMAL, bandmate DECIMAL, stageposition TEXT)
CREATE TABLE instruments (songid DECIMAL, bandmateid DECIMAL, instrument TEXT)
CREATE TABLE songs (songid DECIMAL, title TEXT)
CREATE TABLE tracklists (albumid DECIMAL, position DECIMAL, songid DECIMAL)
CREATE TABLE vocals (songid DECIMAL, bandmate DECIMAL, type TEXT)
CREATE TABLE band (id DECIMAL, firstname TEXT, lastname TEXT)

return all columns of the albums created in the year of 2012.
SELECT * FROM albums WHERE year = 2012
SELECT * FROM "albums" WHERE "year" = 2012