Help with question 8 please!

8. When shopping for a home to buy, you will want to know if the home you are considering is priced competitively. Your real estate agent will generate a list of comparable ("comp") homes to help you make an informed decision. This list will show the address, price, area, number of bathrooms and bedrooms, and the price per square foot of homes in the general vicinity. A home is a comp if the specs are similar to the home you're looking at and has a price/ft,within -5% of yours. Let's say you are considering a home in the 95677 zip code. It has 3 bedrooms, 2 baths, an area of 1,400 ft, and is priced at $264,000. As someone who took an SQL course in college, you want to generate a report of homes whose price per square foot is S189 in the zip code of 95677. The home should have exactly 3 beds and at least 2 baths. In your report, you want to show the address, price, beds, baths, the price per square foot, and whether or not the home is a "comp." as the last column. The last column should display the word "comp" if it's comparable, otherwise be left blank (null). Use the round function to display price information. Your query should return 75 addresses (rows). 9. Using the Customer and Order tables built in previous week labs, create a new table for ordered items, and then populate the table with the following data. Please feel free to recreate the Customer and Order Tables if you need to. Items table OrderlD ItemID tems Bacon Clubhouse Big Mac Soda Hamburger Double-burger Ice cream a. You do not need to submit your create statement as part of this lab assignment. The data in three tables in the database should look like. a. Customer table: William Smith Natalie Lopez Brenda Harper Adam Petrie 8. When shopping for a home to buy, you will want to know if the home you are considering is priced competitively. Your real estate agent will generate a list of comparable ("comp") homes to help you make an informed decision. This list will show the address, price, area, number of bathrooms and bedrooms, and the price per square foot of homes in the general vicinity. A home is a comp if the specs are similar to the home you're looking at and has a price/ft,within -5% of yours. Let's say you are considering a home in the 95677 zip code. It has 3 bedrooms, 2 baths, an area of 1,400 ft, and is priced at $264,000. As someone who took an SQL course in college, you want to generate a report of homes whose price per square foot is S189 in the zip code of 95677. The home should have exactly 3 beds and at least 2 baths. In your report, you want to show the address, price, beds, baths, the price per square foot, and whether or not the home is a "comp." as the last column. The last column should display the word "comp" if it's comparable, otherwise be left blank (null). Use the round function to display price information. Your query should return 75 addresses (rows). 9. Using the Customer and Order tables built in previous week labs, create a new table for ordered items, and then populate the table with the following data. Please feel free to recreate the Customer and Order Tables if you need to. Items table OrderlD ItemID tems Bacon Clubhouse Big Mac Soda Hamburger Double-burger Ice cream a. You do not need to submit your create statement as part of this lab assignment. The data in three tables in the database should look like. a. Customer table: William Smith Natalie Lopez Brenda Harper Adam Petrie