Mysql data analysis project analyzing the sales of house properties in a city in Australia to find
- Which date corresponds to the highest number of sales?
- Find out the postcode with the highest average price per sale?
- (Using Aggregate Functions) Which year witnessed the lowest number of sales?
- Use the window function to deduce the top six postcodes by year's price.