ACCC My SQL Project

According to new research by Harvard University researchers, Starbucks comes by its reputation as the bellwether of gentrification: When the coffee giant colonizes a neighborhood, home prices tend to jump. This research shows that one new Starbucks predicted an extra 0.54 percent rise in local home prices.

Source:

After a Starbucks opens in town, housing prices tend to rise, Harvard study finds (Links to an external site.) (CNBC, September 4 2018)

Starbucks, florists and other warning signs home prices are about to go up (Links to an external site.) (Washington Post, September 6 2018)

In Assignment 5, you will write SQL queries to infer the relationship between house prices in Boston and two national coffee chains: Starbucks and Dunkin Donuts.

———————-

Instruction to Implement the Database Required for Assignment 6

1. Download and unzip the

2. In MySQL Workbench, access the connection and click Server – Data Import. Follow the instructions.

3. Please write your SQL queries directly on this page.