Count the categories
In this chapter, we'll be working mostly with the Evanston 311 data in table evanston311. This is data on help requests submitted to the city of Evanston, IL.
This data has several character columns. Start by examining the most frequent values in some of these columns to get familiar with the common categories.
Bu egzersiz
Exploratory Data Analysis in SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select the count of each level of priority
SELECT ___, ___
___ ___
___ ___;