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

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'