1. Learn
    2. /
  2. Courses
    3. /
  3. Exploratory Data Analysis in SQL

Exercise

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.

Instructions 1/4

undefined XP
  • 1
    • How many rows does each priority level have?
  • 2
    • How many distinct values of zip appear in at least 100 rows?
  • 3
    • How many distinct values of source appear in at least 100 rows?
  • 4
    • Select the five most common values of street and the count of each.