#124. [LeetCode / MySQL] 1517. Find Users With Valid E-Mails

문제  입력 코드SELECT *FROM UsersWHERE mail REGEXP '^[A-Za-z][A-Za-z0-9_\.\-]*@leetcode(\\?com)?\\.com$'SELECT *FROM usersWHERE mail REGEXP '^[a-zA-Z][a-zAZ0-9_.-]*@leetcode[.]com$'  코드 설명#SELECT #WHERE #REGEXP  문제 출처https://leetcode.com/problems/find-users-with-valid-e-mails/description/?envType=study-plan-v2&envId=top-sql-50

• format_list_bulleted SQL
• · 2024. 6. 23.
• textsms

#123. [LeetCode / MySQL] 1327. List the Products Ordered in a Period

문제  입력 코드1.SELECT p.product_name, SUM(o.unit) AS unitFROM Products AS pJOIN Orders AS oUSING(product_id)WHERE o.order_date BETWEEN '2020-02-01' AND '2020-02-29'GROUP BY p.product_id, p.product_nameHAVING SUM(o.unit) >= 100  2.SELECT p.product_name, SUM(o.unit) AS unitFROM Products AS pJOIN Orders AS oUSING(product_id)WHERE MONTH(o.order_date) = 2 AND YEAR(order_date) = 2020GROUP BY o.product_idH..

• format_list_bulleted SQL
• · 2024. 6. 23.
• textsms

#122. [LeetCode / MySQL] 1484. Group Sold Products By The Date

문제  입력 코드SELECT sell_date, COUNT(DISTINCT(product)) AS num_sold, GROUP_CONCAT(DISTINCT(product)) AS productsFROM ActivitiesGROUP BY sell_dateORDER BY sell_dateSELECT sell_date, COUNT(DISTINCT(product)) AS num_sold, GROUP_CONCAT(DISTINCT(product) ORDER BY product ASC SEPARATOR ',') AS productsFROM ActivitiesGROUP BY sell_dateORDE..

• format_list_bulleted SQL
• · 2024. 6. 22.
• textsms

#121. [LeetCode / MySQL] 176. Second Highest Salary

문제  입력 코드1. SELECT ( SELECT DISTINCT Salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 1) AS SecondHighestSalary  2. SELECT DISTINCT MAX(salary) AS SecondHighestSalary FROM EmployeeWHERE salary   코드 설명#SELECT #DISTINCT #ORDER BY #DESC #LIMIT #OFFSET #MAX   문제 출처https://leetcode.com/problems/second-highest-salary/description/?envType=study-plan-v2&envId=top-sql-50

• format_list_bulleted SQL
• · 2024. 6. 22.
• textsms

#120. [LeetCode / MySQL] 196. Delete Duplicate Emails

문제  입력 코드DELETE p1FROM person AS p1, person AS p2WHERE p1.email = p2.email AND p1.id > p2.idDELETE p1FROM person AS p1JOIN person AS p2ON p1.email = p2.emailWHERE p1.email = p2.email AND p1.id > p2.id  코드 설명#DELETE #JOIN #ON #WHERE   문제 출처https://leetcode.com/problems/delete-duplicate-emails/description/?envType=study-plan-v2&envId=top-sql-50

• format_list_bulleted SQL
• · 2024. 6. 21.
• textsms

#119. [LeetCode / MySQL] 1527. Patients With a Condition

문제  입력 코드1. SELECT *FROM PatientsWHERE conditions LIKE 'DIAB1%' OR conditions LIKE '% DIAB1%';  2. REGEXPSELECT *FROM PatientsWHERE conditions REGEXP '\\bDIAB1'  코드 설명#SELECT #WHERE #LIKE #% #REGEXP  문제 출처https://leetcode.com/problems/patients-with-a-condition/description/?envType=study-plan-v2&envId=top-sql-50

• format_list_bulleted SQL
• · 2024. 6. 21.
• textsms