MMIS 63o: Homework 2 Consider the following instance of this database. The Primary key (PK) and Foreign Keys (FK) Tam: INSTALLATIPN ....

SQL

Formulate SQL queries for the following (a and b) with reference to the database schema specified for homework 2. Ensure that your SQL queries will produce a correct response for every valid instance of the database.

a.    

List the employeeid of those salespersons with orders whose salary exceed the salary of their immediate supervisor.

b.   

List those states where the product revenue from transactions between salespersons and customers in the state exceed $1,000,000.