$ python swatMovieDB.py /scratch/soni/swat.db 

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 1


Query returned 27 tuples

fname                lname               
------------------------------------------
Andr¿¿ the Giant                          
Paul                 Badger               
Peter                Cook                 
Billy                Crystal              
Cary                 Elwes                
Peter                Falk                 
Peter                Falk                 
Willoughby           Gray                 
Christopher          Guest                
Mandy                Patinkin             
Derek                Pykett               
Chris                Sarandon             
Fred                 Savage               
Wallace              Shawn                
Mel                  Smith                
Malcolm              Storry               
Betsy                Brantley             
Anne                 Dyson                
Carol                Kane                 
Margery              Mason                
Robin                Wright Penn          
Robin                Wright Penn          
Garrett              Brawith              
Regan                Burns                
Mandy                Patinkin             
Rob                  Reiner               
Lauren               Mora                 

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 2

Enter first name: Kevin
Enter last name: Bacon

Query returned 221 tuples

name                
---------------------
Broadway's Best      
Animal House         
A Few Good Men       
[ More results ]

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 3

Enter actor 1's first name: James
Enter actor 1's last name: Stewart
Enter actor 2's first name: Katharine
Enter actor 2's last name: Hepburn

Query returned [10-15] tuples

name                
---------------------
America at the Movies 
Fonda on Fonda       
[ More results ]

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 4


Query returned [47-53] tuples

fname                lname               
------------------------------------------
Winston              Burdett              
[ More results ]

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 5


Query returned [~50] tuples

fname                lname                numMovies           
---------------------------------------------------------------
 Ellen               Brown                2270                 
[ More results ]             

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 6


Query returned [~20 for distinct, ~25 for not distinct] tuples

fname                lname                NumMovies           
---------------------------------------------------------------
Kyra                 Sedgwick             18                   
[if your roles are not distinct, you'll get Tom Hanks as your top result]                  

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 7


Query returned [~25] tuples
fname                lname                name                 COUNT(DISTINCT S.role)
------------------------------------------------------------------------------------
Robert               Benfer               The Fracktaplots     7               
[ More results ]

Menu of options:
(0) Exit
(1) Query 1
(2) Query 2
(3) Query 3
(4) Query 4
(5) Query 5
(6) Query 6
(7) Query 7
Enter your choice: 0


Thank you for using the SwatMovie Database!