Challenge: Create a Histogram

Try a hands-on exercise to test your knowledge of data modeling.

Problem statement

The most common measure of an earthquake’s size is magnitude. The data based on the magnitude of the aftershocks of an earthquake is given below:

Magnitude: 4.1, 4.2, 4.3, 4.4,…,7.6

Frequency: 19, 21, 12, 29,…,1

Write a query to generate a histogram for the earthquake’s magnitude based on the aftershocks’ frequency.

Get hands-on with 1200+ tech skills courses.