NEW theater Questions

 

  1. When is the next production?
  2. What skilled labor do we have for carpenter?
  3. How many skilled laborers do we have in our database?
  4. Is seat A100 owned by a sponsor?
  5. Who are the new sponsors this year?
  6. What productions has Joe Samsonite been in from 1977 to 1981?
  7. For how many years has Joe Samsonite been a member?
  8. What year did Joe Samsonite become a member?
  9. When did Samsonite last donate?
  10. How many jobs has Samsonite done for the theater?
  11. What is the most popular play?
  12. What is the least popular play?
  13. Have we done a play twice?
  14. Have we done plays by the same writer?
  15. Have we done a play in two different versions?
  16. What seat(s) have been filled the most/
  17. What seat(s) have been filled the least?
  18. What is the theater’s most popular month?
  19. What is the theater’s least popular month?
  20. What genre> of play is the most popular ?
  21. What genre of play is the least popular?
  22. How much of this year’s dues has Mary Brown paid?
  23. What was the seat number for ticket number A232131?
  24. What was the time for “Fiddler on the Roof” on January 3rd, 2004?
  25. What are the different plays that William Donahue would like?
  26. List the sponsors that are patrons as well.
  27. List them members that owe a due balance greater than 24.
  28. How many patrons attended the play on April 31,2005 whose zip codes were NOT 52458?  List with the lay title.
  29. Which sponsors’ donation values are greater than 100?
  30. How much in total has been spent on the auditorium rental fees?
  31. How much in total has been spent on production costs?
  32. How many comedies has the group performed?
  33. Which genre of play is the most well-attended?
  34. How many performances has [group member] participated in?
  35. Which corporate sponsor has donated the most money?
  36. Which auditorium has the greatest seating capacity?
  37. List the title and author(s) or all plays in which [group member] has participated
  38. List all group members grouped by gender and sorted by age
  39. Print mailing labels for all patrons who prefer musicals
  40. Print out a list of patrons who has purchased a ticket for a particular performance with a ticket number below [some ticket number]
  41. Compile a complete financial report of donations and expenses, listing work done by contractors and donations given by sponsors, all grouped by production.