Consider the following relational schema and answer the following questions. Employee (Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct, Manager_Id, Department_Id)   a. Write a query to list the number of jobs available in the

I need help with this SQL query:  Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.

Consider the following relational schema and answer the following questions. Employee (Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct, Manager_Id, Department_Id) a. Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.             b. Write a query to get the department ID and the total salary payable in each department.       c. Write a query to get the average salary for each job ID excluding programmer.       d. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID wise), for department ID 90 only.

Use your ERD to define the table structures in the database using SQL DDL commands to build your schema.