Tasks: Write the SQL statements to answer the following questions.

1. Generate a list of properties (Address, City, State, Zipcode) that were built after 1995.
2. Generate a list of properties (using Address, City, State, Zipcode) in Zipcode 95503 and have at least 3000 SqFt.
3. How many properties were built between 1990-2020?
4. What is the average number of days to sell the houses, including sold and pending properties?
5. How many properties were sold or pending in less than 30 days?

Redwood Properties PropertyID Owner D Address Redwood Customers 7 CustomerID FirstName LastName Address City State Zipcode Home Phone Redwood Listings 9 ListingID PropertyID ListingAgentID SalesStatus BeginList Date Endlist Date Asking Price RedwoodAgents AgentiD FirstName LastName Hire Date Birth Date Gender WorkPhone City State Zipcode Bedrooms Bathrooms Stories SqFt YearBuilt Zone LotSize Redwood Properties PropertyID Owner D Address Redwood Customers 7 CustomerID FirstName LastName Address City State Zipcode Home Phone Redwood Listings 9 ListingID PropertyID ListingAgentID SalesStatus BeginList Date Endlist Date Asking Price RedwoodAgents AgentiD FirstName LastName Hire Date Birth Date Gender WorkPhone City State Zipcode Bedrooms Bathrooms Stories SqFt YearBuilt Zone LotSize