Project 2

Solved in the attached mysql file. I do not have python installed on my machine, so the code needed for question 4 is:

from sqlalchemy import create_engine

import pandas as pd

# make the database engine

engine = create_engine('C:\Users\nikhi\OneDrive\Desktop\Skill Lync\SQL\Local instance MySQL 80\Project 2 csv')

# set the 1000 limit

query = "SELECT * FROM your_table LIMIT 1000;"

# store the result as a dataframe

df = pd.read_sql_query(query, engine)

print(df)