Question: Use tables and data from HW 3 . To send birthday emails, write a query to get the id and full names and email of

Use tables and data from HW3. To send birthday emails, write a query to get the id and full
names and email of customers and directors born in the years second quarter (meaning from
April to June). Use set operations.
2. Use HR tables and data from homework 1. Find a list of employees that earn a salary higher
than 8999 but lower than 17001 within departments Executive and Finance. Use difference
(minus) operation
3. Solve the query on question Part II. Q2(previous question) but using the union operation.
4. Use the intersection operation to solve Part I Q5, but only return the id, first name, last name,
and salary. You must use the operator 3 times.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!