Consider the following SQL database:
I have two questions that I'm struggling on. I'm not really sure where to start.
Select the third largest salary from all the employees. No joins allowed.
Select salaries for all employees with their supervisor’s supervisor that has a salary NOT minimum out of all supervisor salaries. The query MUST use the "ANY" operator.
For the first one, how would I do it if I can't use any joins? I'm assuming I can't just simply use the MAX() function, so I would have to make one myself. I don't know how without using any joins.
For the second one, I'm guessing I would have to join a table to itself?