LeetCode solutions
Every LeetCode problem I have solved, with the accepted code in each language I solved it in. The problem statements stay on LeetCode where they belong — what is here is the solution, the runtime it was accepted at, and a link to the repository it came from.
1,055 solutions
Showing 1–50 of 52 solutions matching SQL, filtered from 1,055.
- 1135. Customers Who Bought All Products Medium Languages: SQL Accepted runtime 489ms
- 1136. Actors and Directors Who Cooperated At Least Three Times Easy Languages: SQL Accepted runtime 356ms
- 1153. Product Sales Analysis I Easy Languages: SQL Accepted runtime 1283ms
- 1155. Product Sales Analysis III Medium Languages: SQL Accepted runtime 628ms
- 1161. Project Employees I Easy Languages: SQL Accepted runtime 448ms
- 1174. Sales Analysis III Easy Languages: SQL Accepted runtime 967ms
- 1179. Game Play Analysis I Easy Languages: SQL Accepted runtime 609ms
- 1182. Game Play Analysis IV Medium Languages: SQL Accepted runtime 528ms
- 1245. User Activity for the Past 30 Days I Easy Languages: SQL Accepted runtime 561ms
- 1258. Article Views I Easy Languages: SQL Accepted runtime 357ms
- 1301. Reformat Department Table Easy Languages: SQL Accepted runtime 486ms
- 1462. List the Products Ordered in a Period Easy Languages: SQL Accepted runtime 638ms
- 1509. Replace Employee ID With The Unique Identifier Easy Languages: SQL Accepted runtime 999ms
- 1541. Top Travellers Easy Languages: SQL Accepted runtime 934ms
- 1625. Group Sold Products By The Date Easy Languages: SQL Accepted runtime 439ms
- 1664. Find Users With Valid E-Mails Easy Languages: SQL Accepted runtime 710ms
- 1670. Patients With a Condition Easy Languages: SQL Accepted runtime 373ms
- 1724. Customer Who Visited but Did Not Make Any Transactions Easy Languages: SQL Accepted runtime 1210ms
- 1734. Bank Account Summary II Easy Languages: SQL Accepted runtime 733ms
- 1773. Percentage of Users Attended a Contest Easy Languages: SQL Accepted runtime 857ms
- 1801. Average Time of Process per Machine Easy Languages: SQL Accepted runtime 215ms
- 1811. Fix Names in a Table Easy Languages: SQL Accepted runtime 567ms
- 1827. Invalid Tweets Easy Languages: SQL Accepted runtime 712ms
- 1837. Daily Leads and Partners Easy Languages: SQL Accepted runtime 462ms
- 1877. Find Followers Count Easy Languages: SQL Accepted runtime 507ms
- 1882. The Number of Employees Which Report to Each Employee Easy Languages: SQL Accepted runtime 1497ms
- 1892. Find Total Time Spent by Each Employee Easy Languages: SQL Accepted runtime 477ms
- 1908. Recyclable and Low Fat Products Easy Languages: SQL Accepted runtime 497ms
- 1942. Primary Department for Each Employee Easy Languages: SQL Accepted runtime 513ms
- 1948. Rearrange Products Table Easy Languages: SQL Accepted runtime 478ms
- 2024. Calculate Special Bonus Easy Languages: SQL Accepted runtime 617ms
- 2041. The Latest Login in 2020 Easy Languages: SQL Accepted runtime 541ms
- 2087. Confirmation Rate Medium Languages: SQL Accepted runtime 574ms
- 2110. Employees With Missing Information Easy Languages: SQL Accepted runtime 506ms
- 2127. Employees Whose Manager Left the Company Easy Languages: SQL Accepted runtime 278ms
- 2495. Number of Unique Subjects Taught by Each Teacher Easy Languages: SQL Accepted runtime 474ms
- 3530. Odd and Even Transactions Medium Languages: SQL Accepted runtime 257ms
- 3711. First Letter Capitalization II Hard Languages: SQL Accepted runtime 364ms
- 3767. Find Students Who Improved Medium Languages: SQL Accepted runtime 280ms
- 3782. Find Valid Emails Easy Languages: SQL Accepted runtime 574ms
- 3792. Find Invalid IP Addresses Hard Languages: SQL Accepted runtime 279ms
- 3803. Find Products with Valid Serial Numbers Easy Languages: SQL Accepted runtime 430ms
- 3816. DNA Pattern Recognition Medium Languages: SQL Accepted runtime 268ms
- 3848. Analyze Subscription Conversion Medium Languages: SQL Accepted runtime 281ms
- 3865. Find Product Recommendation Pairs Medium Languages: SQL Accepted runtime 570ms
- 3891. Find Category Recommendation Pairs Hard Languages: SQL Accepted runtime 675ms
- 3898. Seasonal Sales Analysis Medium Languages: SQL Accepted runtime 490ms
- 3910. Find Books with No Available Copies Easy Languages: SQL Accepted runtime 488ms
- 3996. Find Books with Polarized Opinions Easy Languages: SQL Accepted runtime 512ms
- 4025. Find Loyal Customers Medium Languages: SQL Accepted runtime 285ms
Page 1 of 2
These are practice solutions, not lessons. If you came here to learn how any of it works, the explanations live in the lessons.