SQL 문제
1.[LeetCode] 1757. Recyclable and Low Fat Products
링크 : https://leetcode.com/problems/recyclable-and-low-fat-products/description/?envType=study-plan-v2&envId=top-sql-50
2.[LeetCode] 584. Find Customer Referee
키워드:조건절, None링크:https://leetcode.com/problems/find-customer-referee/?envType=study-plan-v2&envId=top-sql-50회고:SQL 에서 <> 연산자는 "같지 않음"을 의미한다. 즉,
3.[LeetCode] 595. Big Countries
링크: https://leetcode.com/problems/big-countries/description/?envType=study-plan-v2&envId=top-sql-50MySQL
4.[LeetCode] 1148. Article Views I
링크:https://leetcode.com/problems/article-views-i/description/?envType=study-plan-v2&envId=top-sql-50회고:ORDER BY절은 필수적이거나 중요한 결과 정렬 요구 사항을 충족하기 위해
5.[LeetCode] 1683. Invalid Tweets
MySQL에서 문자열의 길이를 구하는 데 LENGTH() 함수와 CHAR_LENGTH() 함수가 있다.LENGTH(): 문자열의 길이를 바이트 단위로 반환. 주로 ASCII 문자열의 길이를 측정할 때 사용.CHAR_LEGNTH():문자열의 길이를 문자의 수로 반환. 유
6.[LeetCode] 1068. Product Sales Analysis I
문제 링크:https://leetcode.com/problems/product-sales-analysis-i/description/?envType=study-plan-v2&envId=top-sql-50MySQL
7.[LeetCode] 1581. Customer Who Visited but Did Not Make Any Transactions
문제 링크:https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/description/?envType=study-plan-v2&envId=top-sql-50MyS
8.[LeetCode] 197. Rising Temperature
https://leetcode.com/problems/rising-temperature/description/?envType=study-plan-v2&envId=top-sql-50MySQL
9.[LeetCode] 1661. Average Time of Process per Machine
https://leetcode.com/problems/average-time-of-process-per-machine/description/?envType=study-plan-v2&envId=top-sql-50AVG(): 평균을 구하는 함수. 그룹화된 데이터의
10.[LeetCode] 577. Employee Bonus
문제 링크:https://leetcode.com/problems/employee-bonus/description/?envType=study-plan-v2&envId=top-sql-50MySQl
11.[LeetCode] 1280. Students and Examinations
https://leetcode.com/problems/students-and-examinations/description/?envType=study-plan-v2&envId=top-sql-50MySQL에서 CROSS JOIN은 두 테이블 간의 모든 가능한 행
12.[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-50IN절로 비교할 때, 인덱스가 설정되어 있다