Frage im Vorstellungsgespräch bei Meta

SQL question is medium difficulty level. be familiar with window function. The case study is about notification. need lots of brainstorming about how to evaluate if the notification success or not.