Database Problems
Master database problems with AI-powered solutions. Get instant coding assistance during your technical interviews for all 88 problems in this category.
Total Problems: 88
Easy: 50
Medium: 32
Hard: 6
Showing 50 of 88 problems
Problems
Scroll within this area to browse all problems
#
Title
Difficulty
Database LeetCode Problems List
- 176. Second Highest Salary - Medium - DatabaseTable: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+----... Topics: Database
- 175. Combine Two Tables - Easy - DatabaseTable: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | personId | int | | lastName | varchar | | firs... Topics: Database
- 180. Consecutive Numbers - Medium - DatabaseTable: Logs +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | num | varchar | +-------... Topics: Database
- 2041. The Latest Login in 2020 - Easy - DatabaseTable: Logins +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp ... Topics: Database
- 1153. Product Sales Analysis I - Easy - DatabaseTable: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | i... Topics: Database
- 182. Duplicate Emails - Easy - DatabaseTable: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-----... Topics: Database
- 1452. Restaurant Growth - Medium - DatabaseTable: Customer +---------------+---------+ | Column Name | Type | +---------------+---------+ | customer_id | int | | name | varc... Topics: Database
- 577. Employee Bonus - Easy - DatabaseTable: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | empId | int | | name | varchar | | su... Topics: Database
- 177. Nth Highest Salary - Medium - DatabaseTable: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+----... Topics: Database
- 196. Delete Duplicate Emails - Easy - DatabaseTable: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-----... Topics: Database
- 1390. Average Selling Price - Easy - DatabaseTable: Prices +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | start_date | date ... Topics: Database
- 1317. Monthly Transactions I - Medium - DatabaseTable: Transactions +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | country | ... Topics: Database
- 608. Tree Node - Medium - DatabaseTable: Tree +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | p_id | int | +-------------+------+ ... Topics: Database
- 595. Big Countries - Easy - DatabaseTable: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area ... Topics: Database
- 602. Friend Requests II: Who Has the Most Friends - Medium - DatabaseTable: RequestAccepted +----------------+---------+ | Column Name | Type | +----------------+---------+ | requester_id | int | | accepter_... Topics: Database
- 1877. Find Followers Count - Easy - DatabaseTable: Followers +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | follower_id | int | +-------------+---... Topics: Database
- 185. Department Top Three Salaries - Hard - DatabaseTable: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar |... Topics: Database
- 197. Rising Temperature - Easy - DatabaseTable: Weather +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | recordDate | date ... Topics: Database
- 1541. Top Travellers - Easy - DatabaseTable: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar... Topics: Database
- 1724. Customer Who Visited but Did Not Make Any Transactions - Easy - DatabaseTable: Visits +-------------+---------+ | Column Name | Type | +-------------+---------+ | visit_id | int | | customer_id | int | +-----... Topics: Database
- 178. Rank Scores - Medium - DatabaseTable: Scores +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | score | decimal | +-----... Topics: Database
- 2024. Calculate Special Bonus - Easy - DatabaseTable: Employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | | s... Topics: Database
- 1415. Students and Examinations - Easy - DatabaseTable: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name | varc... Topics: Database
- 1155. Product Sales Analysis III - Medium - DatabaseTable: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | i... Topics: Database
- 1734. Bank Account Summary II - Easy - DatabaseTable: Users +--------------+---------+ | Column Name | Type | +--------------+---------+ | account | int | | name | varchar | +-... Topics: Database
- 620. Not Boring Movies - Easy - DatabaseTable: Cinema +----------------+----------+ | Column Name | Type | +----------------+----------+ | id | int | | movie ... Topics: Database
- 1278. Product Price at a Given Date - Medium - DatabaseTable: Products +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | new_price | int ... Topics: Database
- 3792. Find Invalid IP Addresses - Hard - DatabaseTable: logs +-------------+---------+ | Column Name | Type | +-------------+---------+ | log_id | int | | ip | varchar | | statu... Topics: Database
- 181. Employees Earning More Than Their Managers - Easy - DatabaseTable: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | sa... Topics: Database
- 184. Department Highest Salary - Medium - DatabaseTable: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar |... Topics: Database
- 3848. Analyze Subscription Conversion - Medium - DatabaseTable: UserActivity +------------------+---------+ | Column Name | Type | +------------------+---------+ | user_id | int | | acti... Topics: Database
- 2057. Count Salary Categories - Medium - DatabaseTable: Accounts +-------------+------+ | Column Name | Type | +-------------+------+ | account_id | int | | income | int | +-------------+----... Topics: Database
- 1174. Sales Analysis III - Easy - DatabaseTable: Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | ... Topics: Database
- 607. Sales Person - Easy - DatabaseTable: SalesPerson +-----------------+---------+ | Column Name | Type | +-----------------+---------+ | sales_id | int | | name ... Topics: Database
- 570. Managers with at Least 5 Direct Reports - Medium - DatabaseTable: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | de... Topics: Database
- 262. Trips and Users - Hard - DatabaseTable: Trips +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | client_id | int | | ... Topics: Database
- 584. Find Customer Referee - Easy - DatabaseTable: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | re... Topics: Database
- 1258. Article Views I - Easy - DatabaseTable: Views +---------------+---------+ | Column Name | Type | +---------------+---------+ | article_id | int | | author_id | int ... Topics: Database
- 619. Biggest Single Number - Easy - DatabaseTable: MyNumbers +-------------+------+ | Column Name | Type | +-------------+------+ | num | int | +-------------+------+ This table may con... Topics: Database
- 1523. Capital Gain/Loss - Medium - DatabaseTable: Stocks +---------------+---------+ | Column Name | Type | +---------------+---------+ | stock_name | varchar | | operation | enum ... Topics: Database
- 1135. Customers Who Bought All Products - Medium - DatabaseTable: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | customer_id | int | | product_key | int | +---... Topics: Database
- 1670. Patients With a Condition - Easy - DatabaseTable: Patients +--------------+---------+ | Column Name | Type | +--------------+---------+ | patient_id | int | | patient_name | varchar |... Topics: Database
- 626. Exchange Seats - Medium - DatabaseTable: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | student | varchar | +-------... Topics: Database
- 596. Classes With at Least 5 Students - Easy - DatabaseTable: Courses +-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +----... Topics: Database
- 2087. Confirmation Rate - Medium - DatabaseTable: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp ... Topics: Database
- 3910. Find Books with No Available Copies - Easy - DatabaseTable: library_books +------------------+---------+ | Column Name | Type | +------------------+---------+ | book_id | int | | tit... Topics: Database
- 586. Customer Placing the Largest Number of Orders - Easy - DatabaseTable: Orders +-----------------+----------+ | Column Name | Type | +-----------------+----------+ | order_number | int | | customer_n... Topics: Database
- 601. Human Traffic of Stadium - Hard - DatabaseTable: Stadium +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | visit_date | date ... Topics: Database
- 1908. Recyclable and Low Fat Products - Easy - DatabaseTable: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | re... Topics: Database
- 1292. Immediate Food Delivery II - Medium - DatabaseTable: Delivery +-----------------------------+---------+ | Column Name | Type | +-----------------------------+---------+ | delive... Topics: Database
- 3942. Find Drivers with Improved Fuel Efficiency - Medium - DatabaseTable: drivers +-------------+---------+ | Column Name | Type | +-------------+---------+ | driver_id | int | | driver_name | varchar | +----... Topics: Database
- 1892. Find Total Time Spent by Each Employee - Easy - DatabaseTable: Employees +-------------+------+ | Column Name | Type | +-------------+------+ | emp_id | int | | event_day | date | | in_time | in... Topics: Database
- 627. Swap Salary - Easy - DatabaseTable: Salary +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | |... Topics: Database
- 1509. Replace Employee ID With The Unique Identifier - Easy - DatabaseTable: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | var... Topics: Database
- 1161. Project Employees I - Easy - DatabaseTable: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +----... Topics: Database
- 1827. Invalid Tweets - Easy - DatabaseTable: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | v... Topics: Database
- 1179. Game Play Analysis I - Easy - DatabaseTable: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int |... Topics: Database
- 1327. Last Person to Fit in the Bus - Medium - DatabaseTable: Queue +-------------+---------+ | Column Name | Type | +-------------+---------+ | person_id | int | | person_name | varchar | | weigh... Topics: Database
- 1182. Game Play Analysis IV - Medium - DatabaseTable: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int |... Topics: Database
- 3898. Seasonal Sales Analysis - Medium - DatabaseTable: sales +---------------+---------+ | Column Name | Type | +---------------+---------+ | sale_id | int | | product_id | int ... Topics: Database
- 3891. Find Category Recommendation Pairs - Hard - DatabaseTable: ProductPurchases +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | product_id | int | | quantity ... Topics: Database
- 183. Customers Who Never Order - Easy - DatabaseTable: Customers +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | +--... Topics: Database
- 1625. Group Sold Products By The Date - Easy - DatabaseTable Activities: +-------------+---------+ | Column Name | Type | +-------------+---------+ | sell_date | date | | product | varchar | +-... Topics: Database
- 1338. Queries Quality and Percentage - Easy - DatabaseTable: Queries +-------------+---------+ | Column Name | Type | +-------------+---------+ | query_name | varchar | | result | varchar | | pos... Topics: Database
- 1837. Daily Leads and Partners - Easy - DatabaseTable: DailySales +-------------+---------+ | Column Name | Type | +-------------+---------+ | date_id | date | | make_name | varchar | | ... Topics: Database
- 585. Investments in 2016 - Medium - DatabaseTable: Insurance +-------------+-------+ | Column Name | Type | +-------------+-------+ | pid | int | | tiv_2015 | float | | tiv_2016 ... Topics: Database
- 1811. Fix Names in a Table - Easy - DatabaseTable: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | va... Topics: Database
- 1245. User Activity for the Past 30 Days I - Easy - DatabaseTable: Activity +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | session_id | int ... Topics: Database
- 2127. Employees Whose Manager Left the Company - Easy - DatabaseTable: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar ... Topics: Database
- 2495. Number of Unique Subjects Taught by Each Teacher - Easy - DatabaseTable: Teacher +-------------+------+ | Column Name | Type | +-------------+------+ | teacher_id | int | | subject_id | int | | dept_id | int ... Topics: Database
- 1480. Movie Rating - Medium - DatabaseTable: Movies +---------------+---------+ | Column Name | Type | +---------------+---------+ | movie_id | int | | title | varcha... Topics: Database
- 1942. Primary Department for Each Employee - Easy - DatabaseTable: Employee +---------------+---------+ | Column Name | Type | +---------------+---------+ | employee_id | int | | department_id | int ... Topics: Database
- 1268. Market Analysis I - Medium - DatabaseTable: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | join_date | da... Topics: Database
- 3932. Find COVID Recovery Patients - Medium - DatabaseTable: patients +-------------+---------+ | Column Name | Type | +-------------+---------+ | patient_id | int | | patient_name| varchar | | ag... Topics: Database
- 3943. Find Overbooked Employees - Medium - DatabaseTable: employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | employee_id | int | | employee_name | var... Topics: Database
- 3782. Find Valid Emails - Easy - DatabaseTable: Users +-----------------+---------+ | Column Name | Type | +-----------------+---------+ | user_id | int | | email ... Topics: Database
- 1882. The Number of Employees Which Report to Each Employee - Easy - DatabaseTable: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar ... Topics: Database
- 3828. Analyze Organization Hierarchy - Hard - DatabaseTable: Employees +----------------+---------+ | Column Name | Type | +----------------+---------+ | employee_id | int | | employee_name ... Topics: Database
- 1664. Find Users With Valid E-Mails - Easy - DatabaseTable: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | name | varchar... Topics: Database
- 1801. Average Time of Process per Machine - Easy - DatabaseTable: Activity +----------------+---------+ | Column Name | Type | +----------------+---------+ | machine_id | int | | process_id |... Topics: Database
- 1136. Actors and Directors Who Cooperated At Least Three Times - Easy - DatabaseTable: ActorDirector +-------------+---------+ | Column Name | Type | +-------------+---------+ | actor_id | int | | director_id | int |... Topics: Database
- 3865. Find Product Recommendation Pairs - Medium - DatabaseTable: ProductPurchases +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | product_id | int | | quantity ... Topics: Database
- 3767. Find Students Who Improved - Medium - DatabaseTable: Scores +-------------+---------+ | Column Name | Type | +-------------+---------+ | student_id | int | | subject | varchar | | scor... Topics: Database
- 3530. Odd and Even Transactions - Medium - DatabaseTable: transactions +------------------+------+ | Column Name | Type | +------------------+------+ | transaction_id | int | | amount ... Topics: Database
- 1462. List the Products Ordered in a Period - Easy - DatabaseTable: Products +------------------+---------+ | Column Name | Type | +------------------+---------+ | product_id | int | | product_... Topics: Database
- 3921. Find Consistently Improving Employees - Medium - DatabaseTable: employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | +--... Topics: Database
- 610. Triangle Judgement - Easy - DatabaseTable: Triangle +-------------+------+ | Column Name | Type | +-------------+------+ | x | int | | y | int | | z | int... Topics: Database
- 1301. Reformat Department Table - Easy - DatabaseTable: Department +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | revenue | int | | ... Topics: Database
Related LeetCode Topics
- Array LeetCode Problems
- Backtracking LeetCode Problems
- Biconnected Component LeetCode Problems
- Binary Indexed Tree LeetCode Problems
- Binary Search LeetCode Problems
- Binary Search Tree LeetCode Problems
- Binary Tree LeetCode Problems
- Bit Manipulation LeetCode Problems
- Bitmask LeetCode Problems
- Brainteaser LeetCode Problems
- Breadth-First Search LeetCode Problems
- Bucket Sort LeetCode Problems
- Combinatorics LeetCode Problems
- Concurrency LeetCode Problems
- Counting LeetCode Problems
- Counting Sort LeetCode Problems
- Data Stream LeetCode Problems
- Depth-First Search LeetCode Problems
- Design LeetCode Problems
- Divide and Conquer LeetCode Problems