There are currently no frequently asked questions associated with this exercise – that’s where you come in! You can contribute to this section by offering your own questions, answers, or clarifications on this exercise. Ask or answer a question by clicking reply () below.
If you’ve had an “aha” moment about the concepts, formatting, syntax, or anything else with this exercise, consider sharing those insights! Teaching others and answering their questions is one of the best ways to learn and stay sharp.
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply () below!
Agree with a comment or answer? Like () to up-vote the contribution!
Once again, this module is plagued with unclear instructions. Here’s the text of the exercise:
Using the same pattern, find the percentage of flights from Delta by origin ( carrier = 'DL' )
In the query, alias the column as percentage_flight_distance_from_delta.
A literal reading of the first part would have the reader conclude the exercise is to determine the percent of the number of flights organized by origin, which would require a row sum [SUM(*)], but then the alias tells us we’re supposed to find the percentage of flight distance…
Perhaps the test creators are trying to teach future data scientists how to deal with unclear requests from management. Maybe there should be a section on business hermeneutics.
I agree with all above. Please tell me this gets better. I thought the beginning SQL stuff was great. But now I’m just clicking through to get to the next topic. and why no cheatsheets?! I use those a lot to study.