Interactive SQL Tutorial

Try it yourself

OwnerID	OwnerLastName	OwnerFirstName	Address	City	State	Country
1	Jones	Bill		London		UK
2	Smith	Bob		Paris	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

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

EmployeeIDNo	SSN	FirstName	LastName	Address	City	State	BirthDate
10	512687458	Joe	Smith	83 First Street	Howard	Ohio	1978-05-10 00:00:00
11	615374542	Jane	WhiteHead	55 Oak st.	London	England	1965-03-15 00:00:00
152	758420012	Mary	Scott	842 Vine Ave.	Losantiville	Ohio	1981-12-21 00:00:00
244	102254896	Sam	Jones	33 Elm St.	Paris	New York	1980-12-31 00:00:00
400	876512563	Sarah	Ackerman	440 U.S. 110	Upton	Michigan	1979-08-15 00:00:00

OwnerID	OwnerLastName	OwnerFirstName	Address	City	State	Country
1	Jones	Bill		London		UK
2	Smith	Bob		Paris	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

OwnerID	ItemDesired
1	Table
2	Desk
15	Mirror
21	Chair
23	Window
55	Bookcase
64	Lamp

OwnerID	OwnerLastName	OwnerFirstName	Address	City	State	Country
1	Jones	Bill		London		UK
2	Smith	Bob		Paris	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

admin

Leave a Reply Cancel reply