MySQL79 leetcode 185 department-top-three-salaries/description https://leetcode.com/problems/department-top-three-salaries/description/ Department Top Three Salaries - LeetCode Can you solve this real interview question? Department Top Three Salaries - Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId | int | +-------------- leetcode.com 1 2 3 4 5 6 7 .. 2023. 11. 16. leetcode 1731. The Number of Employees Which Report to Each Employee https://leetcode.com/problems/the-number-of-employees-which-report-to-each-employee/description/?envType=study-plan-v2&envId=top-sql-50 The Number of Employees Which Report to Each Employee - LeetCode Can you solve this real interview question? The Number of Employees Which Report to Each Employee - Table: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | e.. 2023. 6. 16. leetcode 1211. Queries Quality and Percentage https://leetcode.com/problems/queries-quality-and-percentage/description/?envType=study-plan-v2&envId=top-sql-50 Queries Quality and Percentage - LeetCode Can you solve this real interview question? Queries Quality and Percentage - Table: Queries +-------------+---------+ | Column Name | Type | +-------------+---------+ | query_name | varchar | | result | varchar | | position | int | | rating | .. 2023. 6. 13. leetcode 619. Biggest Single Number https://leetcode.com/problems/biggest-single-number/description/?envType=study-plan-v2&envId=top-sql-50 Biggest Single Number - LeetCode Can you solve this real interview question? Biggest Single Number - Table: MyNumbers +-------------+------+ | Column Name | Type | +-------------+------+ | num | int | +-------------+------+ There is no primary key for this table. It may contain duplicates leet.. 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. 이전 1 2 3 4 ··· 7 다음