Exercise

Identifying invalid parking violations

The parking_violation table has three columns populated by related time values. The from_hours_in_effect column indicates the start time when parking restrictions are enforced at the location where the violation occurred. The to_hours_in_effect column indicates the ending time for enforcement of parking restrictions. The violation_time indicates the time at which the violation was recorded. In order to ensure the validity of parking tickets, an audit is being performed to identify tickets given outside of the restricted parking hours.

In this exercise, you will use the parking restriction time range defined by from_hours_in_effect and to_hours_in_effect to identify parking tickets with an invalid violation_time.

Instructions 1/2

undefined XP
    1
    2
  • Complete the SELECT query to return the summons_number, violation_time, from_hours_in_effect, and to_hours_in_effect for violation_time values, in that order, outside of the restricted range.