FNZ Interview Question

Q: Explain SQL query and understand what it returns