$ python queryDB.py /scratch/asas/movie.db 

Welcome to the Movie Database!

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 1

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

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2

Please enter actor's first name: Samantha
Please enter actor's last name: Goldstein

4 results
Title               
--------------------
Anywhere But Here   
Firetrap            
Surfer Girl House   
The Three Faces of Phoebe

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2

Please enter actor's first name: Kevin
Please enter actor's last name: Bacon

[~215-230 results]
Title               
--------------------
'Hollow Man': Anatomy of a Thriller
[more results]


Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 3

Please enter first actor's first name: James
Please enter first actor's last name: Stewart
Please enter second actor's first name: Katharine
Please enter second actor's last name: Hepburn

[10-15 results]
ID                  Title             
----------------------------------------
86099               America at the Movies
150873              Fonda on Fonda
[more results]

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 4

[~50 results]
FirstName           LastName            NumMovies           
------------------------------------------------------------
Ellen               Brown               2270                
[mores results]

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 5


[~20 results]

FirstName            LastName             NumMovies           
---------------------------------------------------------------
Kyra                 Sedgwick             18                   
[You'll get Tom Hanks as your top result if you double-count movies with multiple roles]                  

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 6

[~25 results]
FirstName           LastName            Title               NumberOfRoles      
--------------------------------------------------------------------------------
Scott               Morales             Is This a Joke?     8
[more results]

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 0


Thank you for using the Movie Database!