SQL PRACTICESQL PracticeAdvancedQuestion 1 of 100%ROW_NUMBERScenario practiceSelect one answerTo select the latest event per account, which pattern is commonly used?AGroup by account_id and select every event columnBROW_NUMBER() OVER (PARTITION BY account_id ORDER BY event_time DESC), then keep row 1CUse COUNT(*) and keep the largest countDSort the whole table and assume the first row per account PreviousSubmit answer