IDT interview question

Basic SQL questions - joins, functions