Questions and Answers
Which customer lives on Negley Avenue?
Aboud
How many customers were born from 2001 onward?
2
Which instructors live in zip code 15217?
Vicki Pegues, Raymond Stein
Which classes (by name) have the highest number of reservations?
Signup and view all the answers
How many customers have registered for a class on Wednesdays?
Signup and view all the answers
What are the three most popular class names on Saturday?
Signup and view all the answers
How many classes did Pablo Brough sign up for?
Signup and view all the answers
How many customers have signed up for a class on January 8, 2021?
Signup and view all the answers
Which customers prefer the 45-minute class length?
Signup and view all the answers
Which instructor teaches the most classes?
Signup and view all the answers
Which instructor teaches Zumba?
Signup and view all the answers
Which customer does not owe another fee besides the class price for reservations containing the word Cycle?
Signup and view all the answers
According to the reservations so far, how much money will the Combination classes generate?
Signup and view all the answers
How many classes does instructor Michael Nguyen have left to teach after canceling his Wednesday class?
Signup and view all the answers
Which instructor will customer Margo Patterson get for her HIIT class?
Signup and view all the answers
How many classes are offered on Tuesday at 6 am and last 45 minutes?
Signup and view all the answers
Which day of the week has the most classes?
Signup and view all the answers
Study Notes
Customer Information
- Aboud lives on Negley Avenue.
- Two customers were born in 2001 or later.
- Six customers registered for a class on Wednesdays.
Instructor Details
- Vicki Pegues and Raymond Stein reside in zip code 15217.
- Maria D'Angelo teaches the most classes.
- Megan Kobinski is the Zumba instructor.
- Customer Margo Patterson's HIIT class will be taught by Raymond Stein.
- Michael Nguyen has five classes left to teach after canceling one on Wednesday due to injury.
Class and Reservation Insights
- The classes with the highest reservations are Intense Cycle and Barre.
- The most popular Saturday classes are Maturity Endurance and Strength, Intense Cycle, and Bootcamp.
- Juan Barry is the only customer who does not owe additional fees for any Cycle class reservations.
- Total revenue generated from Combination classes is $18.
- No classes are offered on Tuesday at 6 am that last 45 minutes.
- Wednesday has the highest number of classes scheduled.
Other Key Facts
- Pablo Brough signed up for two classes.
- Three customers signed up for a class on January 8, 2021.
- Glenn Spencer and Sharon Smith prefer 45-minute class lengths.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge with flashcards from Module 2 of the Pitt Fitness case exercises. This quiz covers customer information, instructors, and class reservations in fitness management. Perfect for students looking to solidify their understanding of the material.
