Jay's Cookbook
Menu
  • Tags
  • Categories
  • Projects
Computer Science
OS
Network
Data Structure
Algorithm
Language
Code Architecture
Python
Javascript
Typescript
Java
Backend
Backend Theory
TypeORM
Node.js
NestJS
FastAPI
Frontend
HTML/CSS
React
Next.js
Data Engineering
DE Theory
MySQL
MongoDB
Elastic
Redis
Kafka
Spark
Airflow
AI
Basic
Pytorch
NLP
Computer Vision
Data Analytics
Statistics
Pandas
Matplotlib
DevOps
Git
Docker
Kubernetes
AWS
[MySQL] SQL 문제
data_engineering
mysql

[MySQL] SQL 문제

Jay Kim
Jay Kim 11 Jul 2022
[MySQL] 그라파나를 이용해 MySQL 서버 모니터링 하기 [MySQL] SQL을 이용한 데이터 분석에서 겪었던 다양한 경험들

Table of Contents

  • SQL

SQL

Leetcode: Database

💟 ✅ ❎

문제 리스트
--------------------------------------------- EASY
- Rearrange Products Table 💟 ❎
- Customer Who Visited but Did Not Make Any Transactions 💟 ✅ 
- Bank Account Summary II 💟 ✅
- Group Sold Products By The Date 💟 ✅
- Immediate Food Delivery I 💟 ✅
- Reformat Department Table 💟 ✅
- Product Sales Analysis I ✅
- Product Sales Analysis II ✅
- The Latest Login in 2020 ✅
- Employees With Missing Information 💟 ✅
- Swap Salary ✅
- Game Play Analysis I ✅
- Primary Department for Each Employee ✅
- Find Customer Referee ✅
- Big Countries ✅
- Customer Placing the Largest Number of Orders ✅
- Customer Order Frequency 💟 ✅
- Combine Two Tables ✅
- Duplicate Emails ✅
- Consecutive Available Seats 💟 ✅
- Employees Earning More Than Their Managers ✅
- Reported Posts 💟 ✅
- Customers Who Never Order ✅
- Fix Product Name Format 💟 ✅
- Delete Duplicate Emails ✅
- User Activity for the Past 30 Days I 💟 ✅
- Sales Analysis II 💟 ✅
- The Number of Employees Which Report to Each Employee 💟 ✅
- Classes More Than 5 Students ✅
- Rising Temperature 💟 ✅
- Friend Requests I: Overall Acceptance Rate 💟 ✅
--------------------------------------------- MEDIUM
- Find the Start and End Number of Continuous Ranges 💟 ❎ 
- Running Total for Different Genders 💟 ❎ 
- All People Report to the Given Manager ✅
- Number of Calls Between Two Persons 💟 ✅
- Game Play Analysis III 💟 ✅
- Customers Who Bought Products A and B but Not C 💟 ✅
- Biggest Window Between Visits 💟 ❎ 
- Evaluate Boolean Expression 💟 ✅
- Tree Node ✅
- Highest Grade For Each Student 💟 ✅
- Number of Accounts That Did Not Stream ✅
- Restaurant Growth 💟 ❎ 
- Exchange Seats 💟 ✅
- Product Price at a Given Date 💟 ❎ 
- Customers Who Bought All Products ❎
- Managers with at Least 5 Direct Reports ✅
- Market Analysis I 💟 ✅
- Find Interview Candidates 💟 ❎ 
- Immediate Food Delivery II 💟 ❎ 
- Shortest Distance in a Plane ✅
- Rank Scores 💟 ✅
- Movie Rating 💟 ✅
- Countries You Can Safely Invest In 💟 ✅
- League Statistics 💟 ✅
- The Number of Passengers in Each Bus I
- Department Highest Salary
- Consecutive Numbers
- Game Play Analysis IV
- Active Users
- Nth Highest Salary
- Second Degree Follower
- Second Highest Salary
- Reported Posts II

--------------------------------------------- HARD
- Sales by Day of the Week
- Median Employee Salary
- Total Sales Amount by Year
- Average Salary: Departments VS Company
- Longest Winning Streak
- Dynamic Pivoting of a Table
- First and Last Call On the Same Day
- Tournament Winners
- The Number of Passengers in Each Bus II
- Human Traffic of Stadium
- Department Top Three Salaries
- Find Median Given Frequency of Numbers
- The Number of Seniors and Juniors to Join the Company
- Trips and Users
[MySQL] 그라파나를 이용해 MySQL 서버 모니터링 하기 [MySQL] SQL을 이용한 데이터 분석에서 겪었던 다양한 경험들

You may also like

See all mysql
12 Jul 2022 [MySQL] SQL을 이용한 데이터 분석에서 겪었던 다양한 경험들
data_engineering
mysql

[MySQL] SQL을 이용한 데이터 분석에서 겪었던 다양한 경험들

03 Jul 2022 [MySQL] 그라파나를 이용해 MySQL 서버 모니터링 하기
data_engineering
mysql

[MySQL] 그라파나를 이용해 MySQL 서버 모니터링 하기

02 Jul 2022 [MySQL] 성능 최적화
data_engineering
mysql

[MySQL] 성능 최적화

Jay Kim

Jay Kim

Web development, data engineering for human for the Earth. I share posts, free resources and inspiration.

Rest
Lifestyle
Hobby
Hobby
Hobby
Hobby
2025 © Jay's Cookbook. Crafted & Designed by Artem Sheludko.