LeetCode342 leetcode 744. Find Smallest Letter Greater Than Target https://leetcode.com/problems/find-smallest-letter-greater-than-target/description/ Find Smallest Letter Greater Than Target - LeetCode Can you solve this real interview question? Find Smallest Letter Greater Than Target - You are given an array of characters letters that is sorted in non-decreasing order, and a character target. There are at least two different characters in letters. Retu leetc.. 2023. 6. 9. leetcode 1517. Find Users With Valid E-Mails https://leetcode.com/problems/find-users-with-valid-e-mails/solutions/748172/mysql-regexp-with-explanation/?envType=study-plan-v2&envId=top-sql-50 1 2 3 4 # Write your MySQL query statement below select * from Users where mail regexp '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode[.]com$' cs 정규식에서 . dot은 임의의 문자 하나에 해당하는 사실..! 잊지 않고 푸시길 바랍니다 in the regular expression. The fact that dot corresponds to any sing.. 2023. 6. 7. leetcode 1633. Percentage of Users Attended a Contest https://leetcode.com/problems/percentage-of-users-attended-a-contest/description/?envType=study-plan-v2&envId=top-sql-50 Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-----------.. 2023. 6. 1. leetcode 570. Managers with at Least 5 Direct Reports https://leetcode.com/problems/managers-with-at-least-5-direct-reports/?envType=study-plan-v2&envId=top-sql-50 Managers with at Least 5 Direct Reports - LeetCode Can you solve this real interview question? Managers with at Least 5 Direct Reports - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | varchar | | m.. 2023. 6. 1. leetcode 570. Managers with at Least 5 Direct Reports https://leetcode.com/problems/managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50 Managers with at Least 5 Direct Reports - LeetCode Can you solve this real interview question? Managers with at Least 5 Direct Reports - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | v.. 2023. 5. 31. leetcode 584. Find Customer Referee https://leetcode.com/problems/find-customer-referee/description/?envType=study-plan-v2&id=top-sql-50 Find Customer Referee - LeetCode Can you solve this real interview question? Find Customer Referee - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+ id is the primary leetcode.. 2023. 5. 29. leetcode 1757. Recyclable and Low Fat Products https://leetcode.com/problems/recyclable-and-low-fat-products/description/?envType=study-plan-v2&id=top-sql-50 Recyclable and Low Fat Products - LeetCode Can you solve this real interview question? Recyclable and Low Fat Products - Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +-----------.. 2023. 5. 29. leetcode https://leetcode.com/problems/last-person-to-fit-in-the-bus/ https://leetcode.com/problems/last-person-to-fit-in-the-bus/ Last Person to Fit in the Bus - LeetCode Can you solve this real interview question? Last Person to Fit in the Bus - 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 1 2 3 4 5 6 7 8 SELECT person_name FROM ( SELECT person_id, perso.. 2023. 4. 21. leetcode 1075. Project Employees I https://leetcode.com/problems/project-employees-i/description/ Project Employees I - LeetCode Can you solve this real interview question? Project Employees I - Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------+ (project_id, employee_id) is th leetcode.com 1 2 3 4 5 6 # Write your MySQL que.. 2023. 4. 21. leetcode 1934. Confirmation Rate https://leetcode.com/problems/confirmation-rate/description/ 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 1 2 3 4 5 6 # Write your MySQL query s.. 2023. 4. 21. leetcode 1431. Kids With the Greatest Number of Candies https://leetcode.com/problems/kids-with-the-greatest-number-of-candies/description/ Kids With the Greatest Number of Candies - LeetCode Can you solve this real interview question? Kids With the Greatest Number of Candies - There are n kids with candies. You are given an integer array candies, where each candies[i] represents the number of candies the ith kid has, and an integer extraCandie leetc.. 2023. 4. 17. leetcode 1661. Average Time of Process per Machine https://leetcode.com/problems/average-time-of-process-per-machine/description/ Average Time of Process per Machine - LeetCode Can you solve this real interview question? Average Time of Process per Machine - 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 1 2 3 4 5 6 # Write your MySQL quer.. 2023. 4. 14. 이전 1 ··· 5 6 7 8 9 10 11 ··· 29 다음