Given the following four tables: Employee (empno (PK), empname, monthlysalary, deptno, mqrnd (FK)) Department (deptno, deptname, deptlocation)…

Given the following four tables:

• Employee (empno (PK), empname, monthlysalary, deptno, mqrnd (FK))
• Department (deptno, deptname, deptlocation)
• Course (erscode (PK), erd_desc, ers_category, ers_duration)
• Offering (of_begin_gate, erscode (FK), offeringlocation, empno (FK))

Write SQL queries for the following:

1. Find Departments with Average Monthly Salary Greater Than 1000.
2. Find Courses with More Than 2 Offerings.