极客神殿

Write a SQL query to get the nth highest salary from the Employee table.#+----+--------+ #| Id | Salary | #+----+--------+ #| 1 | 100 | #| 2 | 200 | #| 3 | 300 | #+----+--------+For example

Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie,the next ranking number should be the next consecutive integer value. #+

Write a SQL query to find all numbers that appear at least three times consecutively.#+----+-----+ #| Id | Num | #+----+-----+ #| 1 | 1 | #| 2 | 1 | #| 3 | 1 | #| 4 | 2 | #| 5 | 1 | #| 6

181. Employees Earning More Than Their ManagersThe Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+---

The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are both foreign keys to the Users_Id at the Users table. Status is an ENUM type of (‘completed’, ‘cancell