Level of Detail #2

Quiz on Level of Detail #2

Use the “All medalists” sheet from Summer_Olympic_medallists_1896-2008. How many countries never had any women athlete in Olympics (use GENDER field .NOC represents country code)

Using Sample-Superstore dataset find the average customer profit in every region. Which Customer segment has lowest average customer profit in most regions?

Which of the following are true about Exclude LOD expressions? [Select all that apply]

Using the “All medalists” sheet from Summer_Olympic_medallists_1896-2008 , how many athletes won all medals(Gold, Silver & Bronze) in Tennis(Discipline)?

From the 1 digit sheet of EMSI_Jobchange_UK , find the city that ranked 3rd in overall contribution to jobs in 2014 in UK. How much % did "Education" industry from this city contributed to overall jobs in 2014 in UK?

Use the Top teams payroll list from Global Sports finances dataset. Use histogram with bin size of 10,000,000 to find how many leagues have average total payroll between 60M AND 70M?

2 thoughts on “Level of Detail #2”

  1. I was marked incorrectly on the first question. I answered that 51 is the number of countries who have never had a woman compete in the Olympics, which is the answer the step-by-step instructions arrive at, but it was marked wrong (with no correct answer provided instead).

    Other than that, these exercises are very helpful!

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top