Questions for Theatre

1. Who were last year's officers?
2. Who has sponsored the theatre for the last 4 years?
3. Has the theater done The King and I?
4. Which patron(s) has attended the most plays?
5. Who was the last person to sit in seat C10?
6. Is the next show sold out?

7. How many 3 consecutive seats are not yet purchased for a performance?
8. How much money was made and lost during the last production?

9. What seats are available?
10. How many plays has the director directed with the company?
11. How many members do you have?
12. How many are active?
13. How much money do you have?

14. What seats are available?
15. What was the cost of a certain play?
16. What play had the most attendance?
17. When is a certain play?
18. Who is the director of the play?
19. What play had the most sponsors?
20. What was the most expensive play?

21. What performance is on April 10^th 2006?
22. Who are the officers of the theater group?
23. Who are the active members for the performance on April 10^th?
24. Are there any seats available for the April 10^th performance
25. Who are the cast members for the April 10^th performance?

26. Who are all the active group members?
27. How many acts did "insert name here" have?
28. Who was on the production team for "some play"
29. Who is in the cast for "some play"?

Who was the lead actor in the April 5 performance of "Cats"?

How many actors have performed this year?

What was the first production this year?

What is the next production this year?

What was the attendance for "Cats" (on April 5^th)

How many producers have been used in the last year?

What is the title of the current production?

Who is sponsoring the current production?

Who are the actors/actresses in the current production?

What was the cost of some play?

How many tickets were sold for the play on September 8^th?

Profits for fiscal year, per play, year to date?

How many tickets were sold on 3/31/06?

How many seats are available on 4/16/06?

How many actors are in a particular play?

Who is the producer of "The Producers" on May 15^th 2006?

Which productions has Mary Sue attended?

How many productions has the theatre company produced ever?

What productions has John Thomas acted in?

Which production has the highest attendance?