Using the database below, import the database as you have done in previous assignments.
Execute queries to produce a csv report for the following questions.
Upload a word file with your query text and the resulting csv file.
Name the CSV files with you_name_question#.csv
Northwind database
1)Create a report that shows the CategoryName and Description from the categories table sorted by CategoryName.
2)Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.
3)Create a report that shows the CompanyName, Fax, Phone, Country, HomePage from the suppliers table sorted by the Country in descending order then by CompanyName in ascending order.
4)Create a report showing OrderDate, ShippedDate, CustomerID, Freight of all orders placed on 21 May 1996.
5)Create a report showing FirstName, LastName, Country from the employees not from United States
6). Create a report that shows all the orders where the freight cost more than $500.
7)Create a report that shows the FirstName, LastName, BirthDate of employees born in the 1950s
8)Create a report that shows the FirstName, LastName, the year of Birthdate as birth year from the employees table.
9). Create a report that shows the CompanyName, ContactName, Fax of all customers that do not have Fax number and sorted by ContactName
10)Create a report that shows the ProductName, UnitsInStock, UnitsOnOrder, ReorderLevel of all products that are up for reorder
USE MySQL Workbench Using the database below, import the database as you have done in previous assignments. Execute queries to produce a csv report for the following questions. Upload a word file with your query text and the resulting csv file. Name the CSV files with you_name_question#.csv Northwind database 1)Create a report that shows the CategoryName and Description from the categories table sorted by CategoryName. 2)Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone. 3)Create a report that shows the CompanyName, Fax, Phone, Country, HomePage from the suppliers table sorted by the Country in descending order then by CompanyName in ascending order. 4)Create a report showing OrderDate, ShippedDate, CustomerID, Freight of all orders placed on 21 May 1996. 5)Create a report showing FirstName, LastName, Country from the employees not from United States 6). Create a report that shows all the orders where the freight cost more than $500. 7)Create a report that shows the FirstName, LastName, BirthDate of employees born in the 1950s 8)Create a report that shows the FirstName, LastName, the year of Birthdate as birth year from the employees table. 9). Create a report that shows the CompanyName, ContactName, Fax of all customers that do not have Fax number and sorted by ContactName 10)Create a report that shows the ProductName, UnitsInStock, UnitsOnOrder, ReorderLevel of all products that are up for reorder