The Perennials

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The analytics team is picking out the platform's always-on event types, the ones that keep firing month after month rather than in short bursts. Return the event types that were active in at least 12 separate calendar months.

Summary

Some events span seasons.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.