CREATE TABLE table_74842 ("Region" CLOB, "Date" CLOB, "Label" CLOB, "Format" CLOB, "Catalog" CLOB)

Which Label has a Region of united states, and a Format of lp album?
SELECT "Label" FROM table_74842 WHERE "Region" = 'united states' AND "Format" = 'lp album'
SELECT "Label" FROM "table_74842" WHERE "Format" = 'lp album' AND "Region" = 'united states'