Podcast
Questions and Answers
Which customer lives on Negley Avenue?
Which customer lives on Negley Avenue?
Aboud
How many customers were born from 2001 onward?
How many customers were born from 2001 onward?
2
Which instructors live in zip code 15217?
Which instructors live in zip code 15217?
Vicki Pegues, Raymond Stein
Which classes (by name) have the highest number of reservations?
Which classes (by name) have the highest number of reservations?
How many customers have registered for a class on Wednesdays?
How many customers have registered for a class on Wednesdays?
What are the three most popular class names on Saturday?
What are the three most popular class names on Saturday?
How many classes did Pablo Brough sign up for?
How many classes did Pablo Brough sign up for?
How many customers have signed up for a class on January 8, 2021?
How many customers have signed up for a class on January 8, 2021?
Which customers prefer the 45-minute class length?
Which customers prefer the 45-minute class length?
Which instructor teaches the most classes?
Which instructor teaches the most classes?
Which instructor teaches Zumba?
Which instructor teaches Zumba?
Which customer does not owe another fee besides the class price for reservations containing the word Cycle?
Which customer does not owe another fee besides the class price for reservations containing the word Cycle?
According to the reservations so far, how much money will the Combination classes generate?
According to the reservations so far, how much money will the Combination classes generate?
How many classes does instructor Michael Nguyen have left to teach after canceling his Wednesday class?
How many classes does instructor Michael Nguyen have left to teach after canceling his Wednesday class?
Which instructor will customer Margo Patterson get for her HIIT class?
Which instructor will customer Margo Patterson get for her HIIT class?
How many classes are offered on Tuesday at 6 am and last 45 minutes?
How many classes are offered on Tuesday at 6 am and last 45 minutes?
Which day of the week has the most classes?
Which day of the week has the most classes?
Flashcards
Who lives on Negley Ave?
Who lives on Negley Ave?
Aboud lives on Negley Avenue.
Customers born after 2000?
Customers born after 2000?
Two customers were born from 2001 onward.
Instructors in zip code 15217?
Instructors in zip code 15217?
Vicki Pegues and Raymond Stein live in zip code 15217.
Most popular class names?
Most popular class names?
Signup and view all the flashcards
Wednesdays' Customer Count?
Wednesdays' Customer Count?
Signup and view all the flashcards
Top Saturday Classes?
Top Saturday Classes?
Signup and view all the flashcards
Pablo Brough's class count?
Pablo Brough's class count?
Signup and view all the flashcards
Jan 8, 2021 sign-ups?
Jan 8, 2021 sign-ups?
Signup and view all the flashcards
Customer prefers 45-min class?
Customer prefers 45-min class?
Signup and view all the flashcards
Instructor teaches most classes?
Instructor teaches most classes?
Signup and view all the flashcards
Who teaches Zumba?
Who teaches Zumba?
Signup and view all the flashcards
No extra fees for Cycle?
No extra fees for Cycle?
Signup and view all the flashcards
Income from Combination classes?
Income from Combination classes?
Signup and view all the flashcards
Michael Nguyen's remaining classes?
Michael Nguyen's remaining classes?
Signup and view all the flashcards
HIIT instructor for Margo?
HIIT instructor for Margo?
Signup and view all the flashcards
Classes on Tue at 6 AM, 45 min?
Classes on Tue at 6 AM, 45 min?
Signup and view all the flashcards
Day with most classes?
Day with most classes?
Signup and view all the flashcards
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.
