Company: NRI Fintech
Difficulty: easy
Problem Description You are given two tables: exam_calendars | Column | Type | Description | |---|---|---| | calendar_id | INTEGER | Identifier of the calendar | | calendar_name | TEXT | Name of the calendar | exam_holiday_calendar_participant | Column | Type | Description | |---|---|---| | calendar_id | INTEGER | Calendar associated with the holiday | | holiday_id | INTEGER | Identifier of the associated holiday | Write an SQL query that returns the names of all calendars that have more than 2 holidays associated with them. Return one column named calendar_name . Notes Count association rows in exam_holiday_calendar_participant ; use COUNT(holiday_id) , not COUNT(DISTINCT holiday_id) . Join rows using calendar_id . The examples establish calendar_id ascending order for the result. Use that order so the output is deterministic. A calendar with exactly 2 associated rows is excluded. Calendars with no matching association rows are excluded. If no calendar qualifies, return an empty resul