Database

Database

• 3497. Analyze Subscription Conversion
• 3482. Analyze Organization Hierarchy
• 3475. DNA Pattern Recognition
• 3465. Find Products with Valid Serial Numbers
• 3451. Find Invalid IP Addresses
• 3436. Find Valid Emails
• 3421. Find Students Who Improved
• 3415. Find Products with Three Consecutive Digits
• 3401. Find Circular Gift Exchange Chains
• 3390. Longest Team Pass Streak
• 3384. Team Dominance by Pass Success
• 3374. First Letter Capitalization II
• 3368. First Letter Capitalization
• 3358. Books with NULL Ratings
• 3338. Second Highest Salary II
• 3328. Find Cities in Each State II
• 3322. Premier League Table Ranking III
• 3308. Find Top Performing Driver
• 3293. Calculate Product Final Price
• 3278. Find Candidates for Data Scientist Position II
• 3268. Find Overlapping Shifts II
• 3262. Find Overlapping Shifts
• 3252. Premier League Table Ranking II
• 3246. Premier League Table Ranking
• 3236. CEO Subordinate Hierarchy
• 3230. Customer Purchasing Behavior Analysis
• 3220. Odd and Even Transactions
• 3214. Year on Year Growth Rate
• 3204. Bitwise User Permissions Analysis
• 3198. Find Cities in Each State
• 3188. Find Top Scoring Students II
• 3182. Find Top Scoring Students
• 3172. Second Day Verification
• 3166. Calculate Parking Fees and Duration
• 3156. Employee Task Duration and Concurrent Tasks
• 3150. Invalid Tweets II
• 3140. Consecutive Available Seats II
• 3126. Server Utilization Time
• 3124. Find Longest Calls
• 3118. Friday Purchase III
• 3103. Find Trending Hashtags II
• 3089. Find Bursty Behavior
• 3087. Find Trending Hashtags
• 3061. Calculate Trapping Rain Water
• 3060. User Activities within Time Bounds
• 3059. Find All Unique Email Domains
• 3058. Friends With No Mutual Friends
• 3057. Employees Project Allocation
• 3056. Snaps Analysis
• 3055. Top Percentile Fraud
• 3054. Binary Tree Nodes
• 3053. Classifying Triangles by Lengths
• 3052. Maximize Items
• 3051. Find Candidates for Data Scientist Position
• 3050. Pizza Toppings Cost Analysis
• 2995. Viewers Turned Streamers
• 2994. Friday Purchases II
• 2993. Friday Purchases I
• 2991. Top Three Wineries
• 2990. Loan Types
• 2989. Class Performance
• 2988. Manager of the Largest Department
• 2987. Find Expensive Cities
• 2986. Find Third Transaction
• 2985. Calculate Compressed Mean
• 2984. Find Peak Calling Hours for Each City
• 2978. Symmetric Coordinates
• 2922. Market Analysis III
• 2893. Calculate Orders Within Each Interval
• 2854. Rolling Average Steps
• 2853. Highest Salaries Difference
• 2837. Total Traveled Distance
• 2783. Flight Occupancy and Waitlist Analysis
• 2752. Customers with Maximum Number of Transactions on Consecutive Days
• 2738. Count Occurrences in Text
• 2720. Popularity Percentage
• 2701. Consecutive Transactions with Increasing Amounts
• 2688. Find Active Users
• 2687. Bikes Last Time Used
• 2686. Immediate Food Delivery III
• 2669. Count Artist Occurrences On Spotify Ranking List
• 2668. Find Latest Salaries
• 2504. Concatenate the Name and the Profession
• 2494. Merge Overlapping Events in the Same Hall
• 2480. Form a Chemical Bond
• 2474. Customers With Strictly Increasing Purchases
• 2394. Employees With Deductions
• 2388. Change Null Values in a Table to the Previous Value
• 2377. Sort the Olympic Table
• 2372. Calculate the Influence of Each Salesperson
• 2362. Generate the Invoice
• 2356. Number of Unique Subjects Taught by Each Teacher
• 2346. Compute the Rank as a Percentage
• 2339. All the Matches of the League
• 2329. Product Sales Analysis V
• 2324. Product Sales Analysis IV
• 2314. The First Day of the Maximum Recorded Degree in Each City
• 2308. Arrange Table by Gender
• 2298. Tasks Count in the Weekend
• 2292. Products With Three or More Orders in Two Consecutive Years
• 2253. Dynamic Unpivoting of a Table
• 2252. Dynamic Pivoting of a Table
• 2238. Number of Times a Driver Was a Passenger
• 2230. The Users That Are Eligible for Discount
• 2228. Users With Two Purchases Within Seven Days
• 2205. The Number of Users That Are Eligible for Discount
• 2199. Finding the Topic of Each Post
• 2175. The Change in Global Rankings
• 2173. Longest Winning Streak
• 2159. Order Two Columns Independently
• 2153. The Number of Passengers in Each Bus II
• 2142. The Number of Passengers in Each Bus I
• 2118. Build the Equation
• 2112. The Airport With the Most Traffic
• 2084. Drop Type 1 Orders for Customers With Type 0 Orders
• 2082. The Number of Rich Customers
• 2072. The Winner University
• 2066. Account Balance
• 2051. The Category of Each Member in the Store
• 2041. Accepted Candidates From the Interviews
• 2026. Low-Quality Problems
• 2020. Number of Accounts That Did Not Stream
• 2010. The Number of Seniors and Juniors to Join the Company II
• 2004. The Number of Seniors and Juniors to Join the Company
• 1990. Count the Number of Experiments
• 1988. Find Cutoff Score for Each School
• 1978. Employees Whose Manager Left the Company
• 1972. First and Last Call On the Same Day
• 1965. Employees With Missing Information
• 1951. All the Pairs With the Maximum Number of Common Followers
• 1949. Strong Friendship
• 1939. Users That Actively Request Confirmation Messages
• 1934. Confirmation Rate
• 1919. Leetcodify Similar Friends
• 1917. Leetcodify Friends Recommendations
• 1907. Count Salary Categories
• 1892. Page Recommendations II
• 1890. The Latest Login in 2020
• 1875. Group Employees of the Same Salary
• 1873. Calculate Special Bonus
• 1867. Orders With Maximum Quantity Above Average
• 1853. Convert Date Format
• 1843. Suspicious Bank Accounts
• 1841. League Statistics
• 1831. Maximum Transaction Each Day
• 1821. Find Customers With Positive Revenue this Year
• 1811. Find Interview Candidates
• 1809. Ad-Free Sessions
• 1795. Rearrange Products Table
• 1789. Primary Department for Each Employee
• 1783. Grand Slam Titles
• 1777. Product's Price for Each Store
• 1767. Find the Subtasks That Did Not Execute
• 1757. Recyclable and Low Fat Products
• 1747. Leetflex Banned Accounts
• 1741. Find Total Time Spent by Each Employee
• 1731. The Number of Employees Which Report to Each Employee
• 1729. Find Followers Count
• 1715. Count Apples and Oranges
• 1709. Biggest Window Between Visits
• 1699. Number of Calls Between Two Persons
• 1693. Daily Leads and Partners
• 1683. Invalid Tweets
• 1677. Product's Worth Over Invoices
• 1667. Fix Names in a Table
• 1661. Average Time of Process per Machine
• 1651. Hopper Company Queries III
• 1645. Hopper Company Queries II
• 1635. Hopper Company Queries I
• 1633. Percentage of Users Attended a Contest
• 1623. All Valid Triplets That Can Represent a Country
• 1613. Find the Missing IDs
• 1607. Sellers With No Sales
• 1596. The Most Frequently Ordered Products for Each Customer
• 1587. Bank Account Summary II
• 1581. Customer Who Visited but Did Not Make Any Transactions
• 1571. Warehouse Manager
• 1565. Unique Orders and Customers Per Month
• 1555. Bank Account Summary
• 1549. The Most Recent Orders for Each Product
• 1543. Fix Product Name Format
• 1532. The Most Recent Three Orders
• 1527. Patients With a Condition
• 1517. Find Users With Valid E-Mails
• 1511. Customer Order Frequency
• 1501. Countries You Can Safely Invest In
• 1495. Friendly Movies Streamed Last Month
• 1484. Group Sold Products By The Date
• 1479. Sales by Day of the Week
• 1468. Calculate Salaries
• 1459. Rectangles Area
• 1454. Active Users
• 1445. Apples & Oranges
• 1440. Evaluate Boolean Expression
• 1435. Create a Session Bar Chart
• 1421. NPV Queries
• 1412. Find the Quiet Students in All Exams
• 1407. Top Travellers
• 1398. Customers Who Bought Products A and B but Not C
• 1393. Capital Gain/Loss
• 1384. Total Sales Amount by Year
• 1378. Replace Employee ID With The Unique Identifier
• 1369. Get the Second Most Recent Activity
• 1364. Number of Trusted Contacts of a Customer
• 1355. Activity Participants
• 1350. Students With Invalid Departments
• 1341. Movie Rating
• 1336. Number of Transactions per Visit
• 1327. List the Products Ordered in a Period
• 1322. Ads Performance
• 1321. Restaurant Growth
• 1308. Running Total for Different Genders
• 1303. Find the Team Size
• 1294. Weather Type in Each Country
• 1285. Find the Start and End Number of Continuous Ranges
• 1280. Students and Examinations
• 1270. All People Report to the Given Manager
• 1264. Page Recommendations
• 1251. Average Selling Price
• 1241. Number of Comments per Post
• 1225. Report Contiguous Dates
• 1212. Team Scores in Football Tournament
• 1211. Queries Quality and Percentage
• 1205. Monthly Transactions II
• 1204. Last Person to Fit in the Bus
• 1194. Tournament Winners
• 1193. Monthly Transactions I
• 1179. Reformat Department Table
• 1174. Immediate Food Delivery II
• 1173. Immediate Food Delivery I
• 1164. Product Price at a Given Date
• 1159. Market Analysis II
• 1158. Market Analysis I
• 1149. Article Views II
• 1148. Article Views I
• 1142. User Activity for the Past 30 Days II
• 1141. User Activity for the Past 30 Days I
• 1132. Reported Posts II
• 1127. User Purchase Platform
• 1126. Active Businesses
• 1113. Reported Posts
• 1112. Highest Grade For Each Student
• 1107. New Users Daily Count
• 1098. Unpopular Books
• 1097. Game Play Analysis V
• 1084. Sales Analysis III
• 1083. Sales Analysis II
• 1082. Sales Analysis I
• 1077. Project Employees III
• 1076. Project Employees II
• 1075. Project Employees I
• 1070. Product Sales Analysis III
• 1069. Product Sales Analysis II
• 1068. Product Sales Analysis I
• 1050. Actors and Directors Who Cooperated At Least Three Times
• 1045. Customers Who Bought All Products
• 627. Swap Salary
• 626. Exchange Seats
• 620. Not Boring Movies
• 619. Biggest Single Number
• 618. Students Report By Geography
• 615. Average Salary: Departments VS Company
• 614. Second Degree Follower
• 613. Shortest Distance in a Line
• 612. Shortest Distance in a Plane
• 610. Triangle Judgement
• 608. Tree Node
• 607. Sales Person
• 603. Consecutive Available Seats
• 602. Friend Requests II: Who Has the Most Friends
• 601. Human Traffic of Stadium
• 597. Friend Requests I: Overall Acceptance Rate
• 596. Classes More Than 5 Students
• 595. Big Countries
• 586. Customer Placing the Largest Number of Orders
• 585. Investments in 2016
• 584. Find Customer Referee
• 580. Count Student Number in Departments
• 579. Find Cumulative Salary of an Employee
• 578. Get Highest Answer Rate Question
• 577. Employee Bonus
• 574. Winning Candidate
• 571. Find Median Given Frequency of Numbers
• 570. Managers with at Least 5 Direct Reports
• 569. Median Employee Salary
• 550. Game Play Analysis IV
• 534. Game Play Analysis III
• 512. Game Play Analysis II
• 511. Game Play Analysis I
• 262. Trips and Users
• 197. Rising Temperature
• 196. Delete Duplicate Emails
• 185. Department Top Three Salaries
• 184. Department Highest Salary
• 183. Customers Who Never Order
• 182. Duplicate Emails
• 181. Employees Earning More Than Their Managers
• 180. Consecutive Numbers
• 178. Rank Scores
• 177. Nth Highest Salary
• 176. Second Highest Salary
• 175. Combine Two Tables