Thanks for the challenges, they are helping me a lot.
I do disagree with the solution to this challenge though. It doesn't take into account that most of the tickets have more than one "Meal Deal" in the same transaction. It is missing a lot of "Meal Deals" that could be misleading to the client. It is missing 7000 "Meal Deals" to the count.
Awesome solution, Kevin!
Way to think outside the parameters of the challenge. This is a perfect example of how, in a real-world scenario, a client may ask for the wrong thing or maybe just not the best thing. As data analysts, we shouldn't just be delivering requested metrics, we should be engaging with our clients and helping them choose the best metrics in the first place. It's the difference between taking data orders and delivering data insights. Well done!