728x90 Tests/Leetcode10 [리트코드] 262. Trips and Users (MySQL) 문제 > leetcode 262. Trips and Users SQL 스키마 & 문제 설명 출처 : leetcode 262. Trips and Users Trips and Users - LeetCode 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 ▶ 나의 풀이 in MySQL #문제 풀이 SELECT Request_at as Day, ROUND(COUNT(IF(Status != 'completed', TRUE, NULL)) / COUNT(*), 2) AS 'Cancellati.. 2021. 5. 28. [리트코드] 601.Human Traffic of Stadium (MySQL) 문제 > leetcode 601. Human Traffic of Stadium SQL 스키마 & 문제 설명 출처 : leetcode 601. Human Traffic of Stadium Human Traffic of Stadium - LeetCode 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 ▶ 나의 풀이 in MySQL #문제 풀이 select distinct t1.* from stadium t1, stadium t2, stadium t3 where t1.people >=.. 2021. 5. 27. [리트코드] 197. Rising Temperature (MySQL) 문제 > leetcode 197. Rising Temperature SQL 스키마 & 문제 설명 출처 : leetcode 197. rising temperature Rising Temperature - LeetCode 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 ▶ 나의 풀이 in MySQL #문제 풀이 SELECT weather.id as 'id' FROM weather JOIN weather w ON DATEDIFF(weather.recordDate, w.recordDat.. 2021. 5. 27. [leetcode] MySQL > 596. Classes More Than 5 Students 문제. leetcode database 180. Consecutive Numbers SQL Schema & Explanation There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the table: +---------+------------+ | student | class | +---------+------------+ | A | Math | | B | English | | C | Math | | D | Biology | | E | Math | | F | Computer | | G | Math | |.. 2021. 2. 8. [leetcode] MySQL > 180. Consecutive Numbers 문제. leetcode database 180. Consecutive Numbers SQL Schema & Explanation 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 | 2 | | 7 | 2 | +----+-----+ For example, given the above Logs table, 1 is the only number that appears consecutively for at least three times. +--.. 2020. 9. 14. [leetcode] MySQL > 183. Customers Who Never Order 문제. leetcode Database 183. Customers Who Never Order SQL Schema & Explanation Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything. Table: Customers. +----+-------+ | Id | Name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Table: Orders. +----+------------+ | Id |.. 2020. 9. 12. 이전 1 2 다음 728x90
