le Table Query Assignment House tion Review 1. Create SQL queries to extract the following from the house table, whose metadata is shown Table: house column name doto type size notes about the data ID street city state Text Text Text Text Text 5 5-digit zip codes only 5 house ID number (primary key 40 street address 20 bedroomsNumber bathrooms Number number of bedrooms; integer number of bathrooms; could end in 5 appraised value or sale price of house value Number first last sold Text 20 fist name of the listing or selling agent Text 20 last name of the listing or selling agent Boolean true ,' sold ; false not sold Figure 4-7: metadata for a table of houses in Figure 4-7: The House ID, streer address, and value for houses in the 19140 zip code under S240,000 The House ID, street address, and value for houses in the 19128 zip code with at least three bedrooms and two bathrooms. The House ID, street address, zip code and value for houses sold by Mark Jones. The street address, value, number of bedrooms and number of bathrooms for houses in the 19116 and 19154 zip codes. a. b. c. d. e. The House ID, street address and value for houses in the 19139 zip code that have not been sold