CSIS 325: Lab 6 SQL Queries
In this lab, you will be working with the following tables in SQL Server. To create and populate these
tables in SQL Server, run the queries that are listed below these tables.
CUSTOMER
CID
CName
Age
Resid_City
BirthPlace
1
BLACK
40
ERIE
TAMPA
2
GREEN
25
CARY
ERIE
3
JONES
30
HEMET
TAMPA
4
MARTIN
35
HEMET
TAMPA
5
SIMON
22
ERIE
ERIE
6
VERNON
60
CARY
CARY
7
WILSON
25
DENVER
AUSTIN
In the CUSTOMER table, CName is the primary key.
RENTALS
Rtn
CID
Make
Date_Out
Pickup
Date_returned
Return_city
1
1
FORD
10 2010-Oct-
CARY
12-Oct-2010
CARY
2
1
GM
01-Nov-2009
TAMPA
05-Nov-2009
CARY
3
1
FORD
01-Jan-2009
ERIE
10-Jan-2009
ERIE
4
2
NISSAN
07 2010-Nov-
TAMPA
5
3
FORD
01 2010-Oct-
