Using the below relation scheme create the following SQL queries.

1. Query that will return the first and last name of customers who rented vechiles for location name "san diego"

2. Query that will return the first and last names of employees assigned to department name "manager"

3. Query that will return first and last name of customers who paid with a credit card

EMPLOYEE

Locationworked Fname Lname Employee#

CUSTOMERS

Fname Lname SSN DriversLicense# Price Age Address

RENTAL LOCATION

LocName LocNumber LocAddress

VEHICLE CLASS

Make Model Economy Luxury

PAYMENT

CreditCard Cash Check

DEPARTMENT

DepNumber DepName