FNZ interview question

Q: Explain SQL query and understand what it returns