If you are skilled in Python. Please help me with this Python code and SQL code. If you need more info on what HW2 and HW3 were, just let me know and I will add more info. I really need help, idk whats actually being asked to do and how to tie in the hw2 & hw3 into this hw4.

Here are the company data files from HW2.

and here is an example of what is inside each file

Here is the CSV file we created in hw3 named company-data.csv

That should be all that is needed for this homework.

Thank you!

Problem Description You need to answer questions about many different companies from many different sectors and these questions are awkward to answer using CSV files and Python code. Solution Description Create a database to hold company data, write a Python script that reads CSV files containing various company data and inserts that data into a database, and write SQL queries that answer various questions about the data in your database. Part 1: Create Company Database Write a database creation script named company schema.sql with create table statements that create a database with the following tables: company with fields ticker, name, sic, addri, addr, city, state, and ip o ticker should be the primary key. sic should be a foreign key referencing the sector table sector with fields sic, name sic should be the primary key. o name comes from the Sector field in the source CSV file. stock price with fields ticker, date, open, high, low, close, adj close, volume ( ticker , date) should be the (composite) primary key. To develop and test your work on the remainder of this assignment you should run your company-schema.sql script to create an SQLite database stored in a file such as company.db