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

1. Write the SQL code to check/identify the properties that had been listed multiple times.
2. Write the SQL code to show the cities where there are more than 50 listings are for sale.
3. Write the SQL code to show the average asking price per SqFt by 5-digit zipcode and sales status.
4. Write the SQL code to find a list of properties (Address, City, State, Zipcode) whose asking prices were more than the average asking prices of those sold properties.
5. Write the SQL code to identify a list of agents (FirstName, LastName) who never sold any listings.

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