Learn

A solution to last week's challenge can be found here!   Nothing makes you feel quite as nostalgic as hearing a song you haven't heard in a while.  That's probably why Billboard magazine has been publishing their "Hot 100" list since 1958. If you aren't familiar, the "Hot 100" list ranks the top 100 singles in the US each year. It can be pretty fun to read through, but let's take a look at who dominated the decades.   This challenge's dataset includes rankings from 1965-2015. Determine which artist(s) created the most top 100 hits in each decade. Then, try the same but with top 10 rankings.   ... View more

A solution to last week's challenge can be found here.    This week's challenge was submitted by @kelly_gilbert   - Thank you for your submission!   I bought a lighted marquee box to decorate my office, and I have had a lot of fun updating the message. However, it takes a long time to sort through the letter tiles to see if I have enough for the message I have in mind.   For this challenge, please build an app that will make sure that I have enough of each letter for my desired message. Note, some tiles can be used for multiple characters (e.g. 6 and 9, O and zero).   You don't need to check the message for fit (although, if you want an extra challenge, my marquee box can hold three rows of eight tiles). ... View more

A solution for last week's challenge can be found here.   For this  week's challenge, you are provided two datasets:   - The first one (Clients) contains each client's information including their Client ID - The second one (Request & Evaluation) contains the client's Request number (which is the same as the Client ID),  "Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional"  field is the name of the customer.   Your tasks are to determine: - For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations", "Exceeded Expectations", or "Met Expectations" for "Status2" - The three customers ("Professional") who provided the highest average rating ... View more

A solution to last week’s challenge can be found here.   Because having a reliable electricity source is important to many people, we tend to notice when the power goes out! While we might expect service outages during severe weather events and other natural disasters, sometimes the culprit is... fluffier and cuter, or slithers.   Using the provided dataset, find out: • How many outage events can we attribute to animals? List the culprits with the count of events in descending order.   Hint Use the animals listed in the "Operative" field and information from the "Article Title" field to replace values of "Animal" with the actual animals.   Note All animal types present in this dataset are included in the "Operative" column. ... View more

A solution to last week's challenge can be found here. This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020. Your Challenge is to figure out for that period: - Which country has the most holidays and how many? - Some holidays are only observed by one country. Which country has the most unique days off and how many? - Which day is the most shared in the world as a holiday and which countries are sharing this holiday? ... View more