Mysql

1. Your task is to create a report (query output) that shows employee names, their hire date and the number of years employed (use DateDiff function.) To accomplish this, create a query that includes the following: a. Employee names concatenated (including TitleOfCourtesy, FirstName and LastName with the alias Employee Name b. HireDate formatted mm/dd/yy (or any format you choose) with the alias Hired c. Show number of years employed with alias Years Employed 2. Your task is to show all orders for which an employee is responsible, the CompanyNames of the CustomerIDs listed in the orders table where the customer country is Germany. To accomplish this, create a query that includes the following: a. Full employee names with an alias b. Customer company names with an alias 3. Your task is to create a report that shows the following: a. Customer names with an alias b. Product names with an alias c. Total price calculated as (UnitPrice*(1-Discount)*Quantity) with the alias Total Price d. Round Total Price to zero decimal places e. Sort by Customer and then by product 4. Your task is to create a report that shows supplier information and the products they supply. Explain why you approached the task as you did in the readme.md file. 5. Your task to create a report that shows meaningful output about products that have an inventory level below 10 units. Your report (query output) should include Supplier names, category names, product prices, units in stock, units on order, reorder level and whether the product has been discontinued. Sort your output by UnitPrice. Your boss would like conclusions about the data.

Here is link for the database code information , opan in MySQL Workbench:

https://docs.google.com/document/d/e/2PACX-1vRivZELgVSpPg9jTH9tSbPQGft7HlsXNV7G_oLUF1We7Dnk0O7K-1Vp9b-GaeBuWZXweSHpS7ciZXJB/pub