FirstName LastName Address         City         State   
--------- -------- --------------- ------------ --------
Joe       Smith    83 First Street Howard       Ohio    
Mary      Scott    842 Vine Ave.   Losantiville Ohio    
Sam       Jones    33 Elm St.      Paris        New York
Sarah     Ackerman 440 U.S. 110    Upton        Michigan
SELECT 4
EmployeeIDNo
------------
010         
105         
152         
215         
244         
SELECT 5
EmployeeIDNo
------------
010         
105         
152         
215         
SELECT 4
EmployeeIDNo
------------
244         
300         
SELECT 2
EmployeeIDNo
------------
400         
441         
SELECT 2
EmployeeIDNo
------------
010         
105         
152         
215         
SELECT 4
EmployeeIDNo
------------
010         
105         
152         
215         
SELECT 4
EmployeeIDNo
------------
010         
105         
152         
215         
244         
300         
335         
SELECT 7
EmployeeIDNo
------------
244         
300         
335         
400         
SELECT 4
EmployeeIDNo
------------
010         
105         
152         
215         
441         
SELECT 5
SSN      
---------
512687458
758420012
SELECT 2
OwnerLastName OwnerFirstName
------------- --------------
Smith         Bob           
Fowler        Sam           
SELECT 2
OwnerLastName OwnerFirstName
------------- --------------
Smith         Bob           
Fowler        Sam           
SELECT 2
SellerID OwnerLastName OwnerFirstName
-------- ------------- --------------
21       Akins         Jane          
50       Fowler        Sam           
01       Jones         Bill          
15       Lawson        Patricia      
02       Smith         Bob           
SELECT 5
last_name item_ordered
--------- ------------
Akins     Chair       
Smith     Desk        
Lawson    Mirror      
Smith     Table       
SELECT 4
   sum      avg
------ --------
455000 50555.56
SELECT 1
  min
-----
12500
SELECT 1
count
-----
    3
SELECT 1
BuyerID    max
------- ------
01       800.0
02      1200.0
15      1400.0
21      1800.0
50      1900.0
SELECT 5
BuyerID    max
------- ------
02      1200.0
15      1400.0
21      1800.0
50      1900.0
SELECT 4
BuyerID
-------
50     
15     
21     
21     
02     
SELECT 5
OwnerLastName
-------------
Jones        
Smith        
Lawson       
Akins        
Fowler       
SELECT 5
OwnerFirstName OwnerLastName
-------------- -------------
Bob            Smith        
Sam            Fowler       
SELECT 2
BuyerID Item
------- ----
SELECT 0
OwnerID OwnerLastName OwnerFirstName OwnerID ItemDesired
------- ------------- -------------- ------- -----------
01      Jones         Bill           02      Table      
01      Jones         Bill           02      Desk       
01      Jones         Bill           21      Chair      
01      Jones         Bill           15      Mirror     
02      Smith         Bob            02      Table      
02      Smith         Bob            02      Desk       
02      Smith         Bob            21      Chair      
02      Smith         Bob            15      Mirror     
15      Lawson        Patricia       02      Table      
15      Lawson        Patricia       02      Desk       
15      Lawson        Patricia       21      Chair      
15      Lawson        Patricia       15      Mirror     
21      Akins         Jane           02      Table      
21      Akins         Jane           02      Desk       
21      Akins         Jane           21      Chair      
21      Akins         Jane           15      Mirror     
50      Fowler        Sam            02      Table      
50      Fowler        Sam            02      Desk       
50      Fowler        Sam            21      Chair      
50      Fowler        Sam            15      Mirror     
SELECT 20
