Question: Using the Olympic file below, use MySQL to answer the following queries: 1 . List the 1 0 Top Countries by # of Total Medals

Using the Olympic file below, use MySQL to answer the following queries:
1. List the 10 Top Countries by # of Total Medals
2. List the Top Country by Total medals in each year the olympics were held
3. List the Top 5 Countries by Gold Medals only
4. Show the Average Age of athletes in the Top 5 countries by total gold medals
5. List the Top 5 Sports by Total MedalsTwo options: You can use the xisx file, but it is easier to import using the sql file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Using the Olympic file below, use MySQL to answer the following queries: 1 . List the 1 0 Top Countries by # of Total Medals 2 . List the Top Country by Total medals in each year the olympics were...

Q:

link for more detail on database below: http://sqlzoo.net/wiki/More_JOIN_operations Data Sciences SQL Test 1. You will have 2 hours to complete this test. At the end of the 2 hours, please send all...

Q:

The CiteSeer UMD collection is a standard text document collection, consisting of abstracts of research articles from Computer Science, which are sampled from the CiteSeer digital library. The...

Q:

Appendix A - The Auckland Energy Case Study- Electricity Bill Processing System Auckland Energy is a new electricity company which has just begun to offer power to the households in West Auckland. It...

Q:

4 easy accounting questions and a comfortable due date. Sorry I can't offer any more tutor credit. Thanks in advance! :-) Question 1: A few years ago, a publishing company in the fourth quarter had a...

Q:

For the COMPANY database, write the proper SQL Statements to answer the following queries using MySQL DBMS. To install MySQL Server in your own environment, please see Web links posted on Course Web...

Q:

PLEASE NOTE BEFORE YOU ANSWER. THIS IS NOT MYSQL, IT IS MONGODB. IF YOU DO NOT KNOW MANGODB, PLEASE DO NOT ANSWER THIS QUESTION. LEAVE IT FOR SOMEONE WHO KNOWS IT. PART 1 Create a collection that...

Q:

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries Compilation of the COVID-19 epidemic data commenced on the 31st of December 2019. First identified in Wuhan, China, and by...

Q:

Assignment - 1 ( Database Management System ) DBAS - 3 2 1 0 0 MM: 2 5 Each query is of 5 marks SI database ER diagram; - Use SI database and answer following queries; - 1 . Use Analytical function...

Q:

In 1983, MGMT eCash Inc. developed a type of cryptographic electronic currency, ecash, which was later used in 1995, as digicash for cryptographic electronic payments. This early form of...

Q:

In your own words, describe what privacy means and what privacy protection companies should give employees.

Q:

Show that for multinomial sampling, X2F = X2. What is E [X2] in (10.9) for a multinomial sample?

Q:

Question 4 ( 5 points ) Retake question Saved FV of a Combination of a Single Lump Sum and a Series of Multiple Equal Sums ( annuity ) : Hellen is planning to retire after 1 5 years. In preparation...

Q:

give rationale why mann whitney test best statistical test for this case : Do significant differences exist between husbands and wives regarding holiday depression? There is an ordinal measure of...

Q:

3. Read the advice column in your daily paper or an online magazine. Bearing in mind what youve read in this chapter, consider the nature of the interpersonal conflicts discussed. What are the...

Q:

Understanding Groups

Q:

4. This week, if you have a disagreement with a friend, roommate, romantic partner, family member, or boss, identify one change you could make to manage and resolve the conflict more productively....