4.8 Using pseudo-code and "rubber ducking"

4.13

select
    *
from
    nyc_311
where
    DATE_PART('month', "created date") = 7
    and "complaint type" = 'Illegal Fireworks'

4.14

select
    *
from
    nyc_311
where
    date_part('month', "created date" :: date) = 7
    and "complaint type" = 'Illegal Fireworks'