Meta interview question

SQL question, related to joins, timestamps