极客神殿

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