Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- MATCH_LOP_EVENT_ID calendar_entry_id
- ,MATCH_LOP_EVENT_TYPE lo_Event_id
- ,MATCH_EVENT_TYPE_ID match_type_id
- ,COUNT(*) events
- FROM SNOWPLOW.DERIVED.USER_MATCH_TOTAL WHERE match_end_date >= CURRENT_DATE - 30 AND MATCH_LOP_EVENT_ID IN
- (SELECT DISTINCT calendar_entry_id FROM
- (SELECT calendar_entry_id, COUNT(*) events2 FROM
- (SELECT
- MATCH_LOP_EVENT_ID calendar_entry_id
- ,MATCH_LOP_EVENT_TYPE lo_Event_id
- ,MATCH_EVENT_TYPE_ID match_type_id
- ,COUNT(*) events
- FROM SNOWPLOW.DERIVED.USER_MATCH_TOTAL WHERE match_end_date >= CURRENT_DATE - 30 GROUP BY ALL) GROUP BY ALL HAVING events2 > 1))
- GROUP BY ALL ORDER BY 1,2,3,4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
