(Solved): Questions: Read the scenario below carefully and answer the following questio ...

???????

Questions: Read the scenario below carefully and answer the following questions accordingly. 1. Prepare SQL scripts that will create the tables in your database and their primary and foreign keys. (20) 2. Prepare insert statements and insert at least ten records into every table. (30) 3. Find the city, country, and employee count of the office that has the highest number of employees. You can safely assume that there is only one office with the highest number of employees. (10) 4. Find the total value of orders from each product line during the years 2004 and 2005 . (10) 5. Find the number of payments and average payments from countries with more than ten payments in descending order by their average payments. (10) 6. Find the customers who have an order of at least $$60,000\$$$ together with the order date and order total in descending order by their order total. (10) 7. Find the first names, last names, and job titles of employees who works in Tokyo together with the first names, last names, and job titles of their supervisors. (10)