Category: sql
Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates. +---------+------------+------------------+ | Id(INT) | Date(DATE) | Temperature(INT) …
Submit your SQL to Leetcode online judge: https://oj.leetcode.com/problems/rank-scores/ Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. …
Puzzle is taken from https://oj.leetcode.com/problems/consecutive-numbers/ Write a SQL query to find all numbers that appear at least three times consecutively. +----+-----+ | Id | Num | +----+-----+ | 1 …
This SQL coding exercise is from oj-online-judge: https://oj.leetcode.com/problems/customers-who-never-order/ Two tables: the Customers table and the Orders table. Write a SQL query to find all customers who does not order …
The SQL coding exercise is from oj-online judge and you could submit your solution to this URL: https://oj.leetcode.com/problems/duplicate-emails/ Write a SQL query to find all duplicate emails in a …