jjjllxx/leetcode-database-question-mysql

MySQL solutions to leetcode database question, divided by difficulty.

Leetcode-database-question-MySQL

MySQL solutions to leetcode database question, divided by difficulty.
To learn MySQL knowledge, you can refer to MySQL-Study-Repo.
This repository focuses on database questions, if want algorithm question solutions from leetcode.Please turn to:
C++ Version: Leetcode-in-cpp
Python3 Version: Leetcode-in-python

Easy

175. Combine Two Tables
182. Duplicate Emails
183. Customers Who Never Order
196. Delete Duplicate Emails
197. Rising Temperature
511. Game Play Analysis I
584. Find Customer Referee
595. Big Countries
607. Sales Person
627. Swap Salary
1050. Actors and Directors Who Cooperated At Least Three Times
1068. Product Sales Analysis I
1084. Sales Analysis III
1141. User Activity for the Past 30 Days I
1148. Article Views I
1173. Immediate Food Delivery I 1211. Queries Quality and Percentage
1251. Average Selling Price
1350. Students With Invalid Departments
1378. Replace Employee ID With The Unique Identifier
1407. Top Travellers
1484. Group Sold Products By The Date
1527. Patients With a Condition
1571. Warehouse Manager
1587. Bank Account Summary II
1633. Percentage of Users Attended a Contest
1667. Fix Names in a Table
1683. Invalid Tweets
1693. Daily Leads and Partners
1729. Find Followers Count
1741. Find Total Time Spent by Each Employee
1757. Recyclable and Low Fat Products
1795. Rearrange Products Table
1821. Find Customers With Positive Revenue this Year
1890. The Latest Login in 2020
1965. Employees With Missing Information

Medium

176. Second Highest Salary
608. Tree Node
1158. Market Analysis I
1193. Monthly Transactions I
1393. Capital Gain/Loss
1445. Apples & Oranges
1699. Number of Calls Between Two Persons

Hard