17 Aug Display Count of Sold Houses by Year, City
Using view WEEK9_LAB_REALESTATE :
1. Display Count of Sold Houses by Year, City
create a view for your query as Query_lab11_ q1
2. Display Count of Sold Houses by Year, City, and HouseType,
create a view for your query as Query_lab11_ q2
3. Display the City, ZipCode, and House( street) that was sold multiple times ( > 2)
create a view for your query as Query_lab11_ q3
4 Display SalesAmount per Year, City, and House Type
create a view for your query as Query_lab11_ q4
