Exploring Texas housing data with SQL

UsingJupyter Notebook, answer each of the following questions. This is an individual lab. You will do your work in Jupyter notebook and must show the code you used to get the answer if it is a code-based question.

Your report submission should be formatted using Markdown and code in Jupyter notebook as follows: The name of the assignment as an H1, your name as an H2, and the date as an H3 all in the first cell block. Add a horizontal line/rule after the cell. The questions should then be answered in individual cells indicated by Q1, Q2, Q3…etc. in H4 format and separated from other questions by horizontal lines/rulers.

In this assignment, you will use SQL to query a data on the Texas housing market (

housing.db

Download housing.db

(Idk how to open this data, if someone could aid with how to, that would be great)

You must write out all queries show how you obtained the results in addition to answering the questions. File Typeshtml (this is will turned in as an HTML)

Return the first 7 records from the housing table

How many records in the data had sales greater than 100 and a median sales price greater than 100000? Write a query to return the result.

Show the number of records in the data that had sales greater than 100 or a median sales price less than 100000 by month. The result should contain two columns: month and num_records.

Return a result that shows the mean annual sales by city and year, excluding cities that begin with the letter H. The result should be in descending order by mean sales, limited to 20 records, and should contain three columns: city, year, and mean_annual_sales

How many sales were there in Austin in December 2010? Return the city, year, and sales in the result.

In 2010 in Austin, which month had the most sales? Return a result that shows the number of sales in Austin in 2010 by month.

In which city-month combinations did the greatest numbers of sales, outside of Austin? Return a result that contains the top five cities’ sales and the month it took place in 2010, excluding Austin.

In which city, year, and month did the fewest sales take place? The result should return four columns: fewest_sales, city, year, and month

For the entire dataset, what were the mean sales in each year?

Return only the years that had mean sales greater than 600. Which years does this include?