Fixing incorrect groupings
One issues with having strings stored in different formats is that you may incorrectly group data. If the same value is represented in multiple ways, your report will split the values into different rows, which can lead to inaccurate conclusions.
In this exercise, you will query from the summer_games_messy table, which is a messy, smaller version of summer_games. You'll notice that the same event is stored in multiple ways. Your job is to clean the event field to show the correct number of rows.
Bu egzersiz
Reporting in SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Pull event and unique athletes from summer_games_messy
SELECT
____,
____ AS athletes
FROM ____
-- Group by the non-aggregated field
GROUP BY ____;