|
||||||||||||||||||||||||||||||||||||||||||||||||
2005 Spring Database Homework 4 Deadline Please refer to the following relation schemas to answer questions using SQL.
1. Retrieve the names of all salespersons. 2. Retrieve the names of all salespersons having an “order”. 3. Retrieve the names of salespersons not having an “order”. 4. Retrieve the names of salespersons having an order with Abernathy Construction. 5. Retrieve the salaries of salespersons having an order with Abernathy Construction. 6. Retrieve the city of all customers having an order with salesperson Jones 7. Retrieve the names of all salespersons with the names of customers who have ordered from them. Include salespersons who have no orders. |
||||||||||||||||||||||||||||||||||||||||||||||||
|