Here is a full list of tables in the test database. All examples in the SQL tutorial works with the following tables:
AntiqueOwners Table
| OwnerID |
OwnerLastName |
OwnerFirstName |
Address |
City |
State |
Country |
| 1 |
Jones |
Bill |
|
London |
|
UK |
| 2 |
Smith |
Bob |
|
New York |
New York |
USA |
| 5 |
Jenifer |
Lopes |
|
Paris |
|
France |
| 15 |
Lawson |
Patricia |
|
Los Angeles |
|
USA |
| 21 |
Akins |
Jane |
77, Lincoln st. |
Kirkland |
Washington |
USA |
| 50 |
Fowler |
Sam |
|
Losantiville |
|
USA |
Antiques Table
| SellerID |
BuyerID |
Item |
Price |
ItemID |
| 1 |
50 |
Bed |
350 |
3 |
| 1 |
21 |
Cabinet |
400 |
66 |
| 1 |
15 |
Jewelry Box |
200 |
7 |
| 2 |
15 |
Table |
750 |
1 |
| 2 |
21 |
Coffee Table |
375 |
4 |
| 2 |
21 |
Pottery |
450 |
16 |
| 10 |
5 |
Boocase |
260 |
55 |
| 15 |
2 |
Chair |
370 |
21 |
| 15 |
50 |
Chair |
325 |
21 |
| 21 |
50 |
Mirror |
500 |
15 |
| 50 |
1 |
Desk |
850 |
2 |
| 50 |
1 |
Plant Stand |
250 |
22 |
EmployeeAddressTable Table
| EmployeeIDNo |
SSN |
FirstName |
LastName |
Address |
City |
State |
BirthDate |
| 10 |
512687458 |
Joe |
Smith |
83 First Street |
Howard |
Ohio |
10.05.1978 |
| 11 |
615374542 |
Jane |
WhiteHead |
55 Oak st. |
London |
England |
15.03.1965 |
| 152 |
758420012 |
Mary |
Scott |
842 Vine Ave. |
Losantiville |
Ohio |
21.12.1981 |
| 244 |
102254896 |
Sam |
Jones |
33 Elm St. |
New York |
New York |
31.12.1980 |
| 400 |
876512563 |
Sarah |
Ackerman |
440 U.S. 110 |
Upton |
Michigan |
15.08.1979 |
EmployeeStatisticsTable Table
| EmployeeIDNo |
Salary |
Benefits |
Position |
| 10 |
75 000,00 |
15 000,00 |
Manager |
| 105 |
65 000,00 |
15 000,00 |
Manager |
| 152 |
60 000,00 |
15 000,00 |
Manager |
| 215 |
60 000,00 |
12 500,00 |
Manager |
| 244 |
50 000,00 |
12 000,00 |
Staff |
| 300 |
45 000,00 |
10 000,00 |
Staff |
| 335 |
40 000,00 |
10 000,00 |
Staff |
| 400 |
32 000,00 |
7 500,00 |
Entry-Level |
| 441 |
28 000,00 |
7 500,00 |
Entry-Level |
Orders Table
| OwnerID |
ItemDesired |
| 1 |
Table |
| 2 |
Desk |
| 15 |
Mirror |
| 21 |
Chair |
| 23 |
Window |
| 55 |
Bookcase |
| 64 |
Lamp |
