With the given information, create create SQL statements for the following:

Provide a query that list all houses for sale (MLS#, asking price and Customer ID) with customer name, and phone number;

Provide a query that list all houses for sale (MLS#) and the number of days on the market;

Provide a query that list of customers (name, customer ID, and date of application) along with the MLS#, address, number of viewings that viewed a particular house.

Q, ustomer Field Name CustomerlD Name DatcofApplication Address PContactNo SContactNo Email WPhone WAddress WEmail SpouseNane SpouscEmail Spouse Address Spouse WEmail Spouse WPhone SpouseDriverl iscence SpouscDriverstate Type/Keys INT PK VARCHAR DATE VARCIHAR VARCHAR Primary Contact VARCIIARSecondary Contact VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAIR VARCHAR VARCHAR ! eription ustemer Typc NoOIC hldren VARCHAR INT Type of customer Buyer Sellerh