The northwind file can be downloaded online from any microsoft server i just could not include the link because chegg does not allow it Part $1-$ SQL Statements $(19$ marks$)$ You will be using the Northwind database in MySQL$.$ The script to install the database is included as an attachment with this document. Please provide the answers to the following questions as statements in one executable script file. Please comment each answer to indicate the question it addresses. Questions $-$ Unless otherwise stated, write a single SQL statement to provide an answer to each of the following: $1.$ What is each category called, and how many different products are there in each category? $(3$ marks$)2.$ For each Territory Description, what is the name of the Employee responsible for it$?(2$ marks$)3.$ For each Region Description $($in the Region table$),$ how many employees are there? $(3$ marks$)4.$ Which product has the highest number of units in stock, and what is that number? $(3$ marks$)5.$ For each Order Detail, what is the product name, quantity sold, orderID, order date and customer's company name? Make sure this is sorted by order ID$,$ then by product name. $(4$ marks$)6.$ Remove the LastName and PostalCode indexes on the Employees table. You may use two statements. $(2$ marks$)7.$ Add an index for the City on the Employees table. $(2$ marks$)$ Part $2-$ Written Answers $(6$ marks$)$ Please provide the written answers to these questions in a Word document. $1.$ When you connect to a database from an application like Excel, what are critical pieces of information you need to supply to make a successful connection? $(3$ marks$)2.$ What is a log file $($Binary Log file$)$ and how can you keep its size manageable? $(3$ marks$)$ Put both the SQL script file and Word document in a zipped folder and upload it to the Assignments folder for this Test.