% python queryDB.py /local/tiacs44/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                

Satisfied in 0.000 seconds

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: Goldtein

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

Satisfied in 0.003 seconds

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

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

Satisfied in 0.011 seconds

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 results]
ID                  Title               
----------------------------------------
86099               America at the Movies
150873              Fonda on Fonda      
[more results]

Satisfied in 0.016 seconds

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                
[more results]

Satisfied in 0.394 seconds

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                  
[Tom Hanks will be top result if you double count movies with multiple roles]
[more results]

Satisfied in 5.269 seconds

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]

Satisfied in 6.581 seconds

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!