Consider the following schema for a database that keeps the information

about business trips and their associated expenses by employees:

a$.$ Get a list of all the different destination cities where the employees have taken

trips.

b$.$ Find all the employee information for employees who work in Department $4.$

c$.$ Get complete trip records $($but not their associated expenses$)$ for all trips with

departure dates after July $1$ of the current year.

d$.$ Find the names of all employees who have departed on trips from Shanghai.

e$.$ Find the SSN of all employees who have any single expense item of more than

$$1500$ for any trip.

f$.$ Find the names of all employees who have any expense item with value

$$Entertainment$.$

g$.$ Find the destination cities of all trips taken by employees who have the job title of

$$Manager$.$

h$.$ Find the names and departments of all employees who have a single expense item

of over $$500$ since January $1$ of this year.

i$.$ Find the items and amounts of all expenses for a trip to Cairo beginning on

January $10$ of this year taken by employee Jane.

j$.$ Find the names, departments, and job titles of all employees who have any expense

item with value $$Service Charge$$ for trips taken to NYC last year, along with the

date and amount of the expense.