ToDo_DATA

https://www.hackerrank.com/challenges/weather-observation-station-5 Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com with base as ( select city, length(city) len , dense_rank() over (order by length(city), city) rn1 , dense_rank() over (order by length(city) desc, city) rn2 from..

https://leetcode.com/problems/rising-temperature LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com with base as ( select id, recordDate, temperature , lag(recordDate, 1) over (order by recordDate) last_d , lag(temperature, 1)..

https://leetcode.com/problems/confirmation-rate Confirmation Rate - LeetCode Can you solve this real interview question? Confirmation Rate - Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the prima leetcode.com with base as ( select user_id , count(distinct if(a..

https://leetcode.com/problems/exchange-seats Exchange Seats - LeetCode Can you solve this real interview question? Exchange Seats - Table: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | student | varchar | +-------------+---------+ id is the primary key (unique value) column for leetcode.com select case when id = (select max(id) from Seat) and id%2..

https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends Friend Requests II: Who Has the Most Friends - LeetCode Can you solve this real interview question? Friend Requests II: Who Has the Most Friends - Table: RequestAccepted +----------------+---------+ | Column Name | Type | +----------------+---------+ | requester_id | int | | accepter_id | int | | accept_date | leetcode.com..

https://leetcode.com/problems/game-play-analysis-iv Game Play Analysis IV - LeetCode Can you solve this real interview question? Game Play Analysis IV - Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------- leetcode.com with cond as ( select distinct player_id , ..

https://leetcode.com/problems/human-traffic-of-stadium LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com with base as ( select distinct id, visit_date, people , id - row_number() over (order by id) as rn from Stadium where pe..

https://leetcode.com/problems/trips-and-users select t.request_at as Day , round(1.00*count(distinct(if(t.status like 'cancel%', t.id, null)))/count(distinct t.id), 2) as 'Cancellation Rate' from trips t left join users u on t.client_id = u.users_id and u.role = 'client' and u.banned = 'No' left join users u2 on t.driver_id = u2.users_id and u2.role = 'driver' and u2.banned = 'No' where u.users_..