Frage im Vorstellungsgespräch bei Meta

SQL: how to count something. How to use the union function to count something conditional on something else. Case: How to implement video chat. (SQL was a toy model of chat data)