Which Label has a Region of united states, and a Format of lp album?
CREATE TABLE table_74842 (
    "Region" text,
    "Date" text,
    "Label" text,
    "Format" text,
    "Catalog" text
)
SELECT "Label" FROM table_74842 WHERE "Region" = 'united states' AND "Format" = 'lp album'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Which Label has a Region of united states, and a Format of lp album? ### Input: CREATE TABLE table_74842 (
    "Region" text,
    "Date" text,
    "Label" text,
    "Format" text,
    "Catalog" text
) ### Response: SELECT "Label" FROM table_74842 WHERE "Region" = 'united states' AND "Format" = 'lp album'