(Download the attached tb.csv and tb.sql (located here https://www.dropbox.com/s/0vv9rn5x414ce15/tb%20%281%29.sql?dl=0) files and copy the files to a folder on your local machine. Ensure you remember where you are downloading the files, as you will have to point the MySQL script to the CSV file to load data into a new schema.Launch MySQL workbench.Create a new MySQL schema (database) called “tb” (short for tuberculosis).Make the tb database yor default schema.Open the script tb.sql. If you copied the files to a different folder than the one in the script , you’ll need to modify the LOAD command to point to the correct file location.Run the tb.sql script. You should verify that 3,800 rows were successfully loaded.)1. Use the tb database that you restored earlier Also, the attached population.csv has populations by country for the years where tuberculosis (tb) cases have been reported.2. Load the population.csv file into a newly created table called “population”.3. Join the tables (in SQL) and output the following columns:Country, Year, Rate. Rate is defined as Cases/Population. [HINT: You’ll need to sum the cases across gender and age groups. Ensure you handle NULL (missing values) as you are adding up cases. In MySQL, 1 + 0 = 0, whereas 1 + null = null.To handle NULL values, research (books or internet) how to handle NULLs so that additions are apporiately handled by converting NULLs to zeros.].4. Create a CSV file, and load it as a Pivot Table in LibreOfficeYour deliverables are:1. Your SQL code that performs aggregations and joins the tables.2. The LibreOffice file with the pivot table showing total cases per country and year (with countries on the rows, and year on the columns of the pivot table).
