$ python swatMovieDB.py /scratch/asas/movie.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: Samantha 
Enter last name: Goldstein

Query returned 4 tuples

name                
---------------------
Anywhere But Here    
Firetrap             
The Three Faces of Phoebe 
Surfer Girl House    

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: Patrick        
Enter actor 1's last name: Stewart
Enter actor 2's first name: Ian
Enter actor 2's last name: McKellen

[ Results omitted 20-30 tuples ]

Enter your choice: 4
[ Results omitted 45-55 tuples ]

Enter your choice: 5

Query returned XX tuples

fname                lname                numMovies           
---------------------------------------------------------------
 Ellen               Brown                2270  
 ...

 
Enter your choice: 6
[ Results omitted; ~25 tuples ]

Enter your choice: 7
[ Results omitted: ~25 tuples ]

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!