Consider the following database schema for Greensboro Shop Items(itemID string, name string, description string, gtvInStock integer) Departments deptID string, name string, location string, telNumber string, budget real, manager string) Suppliers(supID string, name string, address string, city string, state string) Orders(ordID string.ordDate date, shipAddress string) Employees(empID string, firstName string, lastName string, ssn string, telNumber string, salary real) Carries(deptID string, itemID string) SupplielitemlD string, supID string, price real) Includes(itemlD string, ordD string, qty integer) Worksln(deptlD string, emplD string) Write SQL queries that answer the following questions based on the database GShop in the ANSI style JOIN. Each question should be answered by one SQL statement only. The result of each statement must not contain duplicates, but you should use the SQL keyword distinct only when necessary. For clarity, each output column should be properly renamed. For example, the output column of name from the table departments may be renamed as "Department Name." Put your SQL query statements and their results into a SQL script file. Run your SQL statements on the MySQL Database Server. Make sure that your SQL script file does not contain any syntax errors