Display Count of Sold Houses by Year, City

17 Aug Display Count of Sold Houses by Year, City

Posted at 13:56h in computer science by

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