
[Pandas] 1-3: 1.판다스 시작하기/ 2.판다스 데이터프레임과 시리즈/ 3.그래프 그리기

[Pandas] 4-6:1.데이터 연결하기 / 2.누락값 처리하기 / 3.깔끔한 데이터

[Pandas] 7-9 :1.판다스 자료형 /2.문자열 처리하기 /3.apply 메서드 활용

[Pandas 10-11] : 1.그룹 연산 /2.시계열 데이터 데이터 집계하기

[SQL] PART 1 -특정 열(column) 선택 -모든 열(column) 출력 -컬럼명 변경하기 -연결 연산자 -중복 데이터 제거 -데이터 정렬 -Where절 -산술 연산자 -비교 연산자 -논리 연산자

[SQL] PART 2

PART3

[HackerRank/SQL] Basic Select 문제풀이

[HackerRank/SQL] Advanced Select

[HackerRank/SQL] Aggregation

[HackerRank/SQL] Basic Join

[HackerRank/SQL] Advanced Join

[HackerRank/SQL] Alternative Queries

[LeetCode/SQL] 175. Combine Two Tables

[LeetCode/SQL] 181. Employees Earning More Than Their Managers

[LeetCode/SQL] 182. Duplicate Emails

[LeetCode/SQL] 183. Customers Who Never Order

[LeetCode/SQL] 196. Delete Duplicate Emails

[LeetCode/SQL] 197. Rising Temperature

[LeetCode/SQL] 577. Employee Bonus

[LeetCode/SQL] 584. Find Customer Referee

[LeetCode/SQL] 586. Customer Placing the Largest Number of Orders

[LeetCode/SQL] 595. Big Countries

[LeetCode/SQL] 596. Classes More Than 5 Students

[LeetCode/SQL] 607. Sales Person

[LeetCode/SQL] 610. Triangle Judgement

[LeetCode/SQL] 619. Biggest Single Number

[LeetCode/SQL] 620. Not Boring Movies

[LeetCode/SQL] 627. Swap Salary

[LeetCode/SQL] 1050. Actors and Directors Who Cooperated At Least Three Times

[LeetCode/SQL] 1068. Product Sales Analysis I

[LeetCode/SQL] 1068. Product Sales Analysis I

[LeetCode/SQL] 1075. Project Employees I

[LeetCode/SQL] 1084. Sales Analysis III

[LeetCode/SQL] 1084. Sales Analysis III

[LeetCode/SQL] 511. Game Play Analysis I

[LeetCode/SQL] 511. Game Play Analysis I

[LeetCode/SQL] 1141. User Activity for the Past 30 Days I

[LeetCode/SQL] 1148. Article Views I

[LeetCode/SQL] 1179. Reformat Department Table

[LeetCode/SQL] 1211. Queries Quality and Percentage

[LeetCode/SQL] 1251. Average Selling Price

[LeetCode/SQL] 1280. Students and Examinations

[LeetCode/SQL] 1327. List the Products Ordered in a Period

[LeetCode/SQL] 1327. List the Products Ordered in a Period

[LeetCode/SQL] 1378. Replace Employee ID With The Unique Identifier

[LeetCode/SQL] 1407. Top Travellers

[LeetCode/SQL] 1484. Group Sold Products By The Date

[LeetCode/SQL] 1517. Find Users With Valid E-Mails

[LeetCode/SQL] 1581. Customer Who Visited but Did Not Make Any Transactions

[LeetCode/SQL] 1527. Patients With a Condition

[LeetCode/SQL] 1587. Bank Account Summary II

[LeetCode/SQL] 1633. Percentage of Users Attended a Contest

[LeetCode/SQL] 1661. Average Time of Process per Machine

[LeetCode/SQL] 1667. Fix Names in a Table

[LeetCode/SQL] 1683. Invalid Tweets

[LeetCode/SQL] 1693. Daily Leads and Partners

[LeetCode/SQL] 1729. Find Followers Count

[LeetCode/SQL] 1731. The Number of Employees Which Report to Each Employee

[LeetCode/SQL] 1741. Find Total Time Spent by Each Employee

[LeetCode/SQL] 1757. Recyclable and Low Fat Products

[LeetCode/SQL] 1789. Primary Department for Each Employee

[LeetCode/SQL] 1789. Primary Department for Each Employee

[LeetCode/SQL] 1789. Primary Department for Each Employee

[LeetCode/SQL] 1795. Rearrange Products Table

[LeetCode/SQL] 1890. The Latest Login in 2020

[LeetCode/SQL] 1965. Employees With Missing Information

[LeetCode/SQL] 1978. Employees Whose Manager Left the Company

[LeetCode/SQL] 2356. Number of Unique Subjects Taught by Each Teacher

[LeetCode/SQL] 176. Second Highest Salary

[LeetCode/SQL] 177. Nth Highest Salary

[LeetCode/SQL] 178. Rank Scores

[LeetCode/SQL] 180. Consecutive Numbers

[LeetCode/SQL] 184. Department Highest Salary

[LeetCode/SQL] 570. Managers with at Least 5 Direct Reports

[LeetCode/SQL] 585. Investments in 2016

[LeetCode/SQL] 602. Friend Requests II: Who Has the Most Friends

[LeetCode/SQL] 602. Friend Requests II: Who Has the Most Friends

[LeetCode/SQL] 608. Tree Node

[LeetCode/SQL] 626. Exchange Seats

[LeetCode/SQL] 1045. Customers Who Bought All Products

[LeetCode/SQL] 1070. Product Sales Analysis III

[LeetCode/SQL] 550. Game Play Analysis IV

[LeetCode/SQL] 1158. Market Analysis I

[LeetCode/SQL] 1164. Product Price at a Given Date

[LeetCode/SQL] 1174. Immediate Food Delivery II

[LeetCode/SQL] 1193. Monthly Transactions I

[LeetCode/SQL] 1204. Last Person to Fit in the Bus

[LeetCode/SQL] 1321. Restaurant Growth

[LeetCode/SQL] 1341. Movie Rating

[LeetCode/SQL] 1393. Capital Gain/Loss

[LeetCode/SQL] 1907. Count Salary Categories

[LeetCode/SQL] 1934. Confirmation Rate

[LeetCode/SQL] 185. Department Top Three Salaries

[LeetCode/SQL] 262. Trips and Users