175. Combine Two Tables
Write a solution to report the first name, last name, city, and state of each person in the `Person` table. If the address of a `personId` is not present in the `Address` table, report null instead.
Write a solution to report the first name, last name, city, and state of each person in the `Person` table. If the address of a `personId` is not present in the `Address` table, report null instead.
Write a solution to find the second highest salary from the `Employee` table. If there is no second highest salary, return `null` (return `None` in Pandas).
Write a solution to find the nth highest salary from the `Employee` table. If there is no nth highest salary, return `null`.
Write a solution to find the rank of the scores.
Write a solution to find the employees who earn more than their managers.
Write a solution to report all the duplicate emails. Note that it's guaranteed that the email field is not `NULL`.
Write a solution to find all customers who never order anything.
Write a solution to delete all duplicate emails, keeping only one unique email with the smallest id. After running your script, the answer shown is the `Person` table. The driver will first compile and run your piece of code and then show the `Person` table. The final order of the `Person` table does not matter.
Find all dates' `Id` with higher temperatures compared to its previous dates (yesterday).
Write a solution to find the first login date for each player.
Write a solution to find the names of all the salespersons who did not have any orders related to the company with the name `RED`.
Tổng hợp các tutorials, solutions cho các problems...