Files

C#
C++
Golang
Java
Kotlin
MySQL
- accepted-candidates-from-the-interviews.sql
- account-balance.sql
- active-businesses.sql
- active-users.sql
- activity-participants.sql
- actors-and-directors-who-cooperated-at-least-three-times.sql
- ad-free-sessions.sql
- ads-performance.sql
- all-people-report-to-the-given-manager.sql
- all-the-matches-of-the-league.sql
- all-the-pairs-with-the-maximum-number-of-common-followers.sql
- all-valid-triplets-that-can-represent-a-country.sql
- analyze-organization-hierarchy.sql
- analyze-subscription-conversion.sql
- apples-oranges.sql
- arrange-table-by-gender.sql
- article-views-i.sql
- article-views-ii.sql
- average-salary-departments-vs-company.sql
- average-selling-price.sql
- average-time-of-process-per-machine.sql
- bank-account-summary-ii.sql
- bank-account-summary.sql
- big-countries.sql
- biggest-single-number.sql
- biggest-window-between-visits.sql
- bikes-last-time-used.sql
- binary-tree-nodes.sql
- bitwise-user-permissions-analysis.sql
- books-with-null-ratings.sql
- build-the-equation.sql
- calculate-compressed-mean.sql
- calculate-orders-within-each-interval.sql
- calculate-parking-fees-and-duration.sql
- calculate-product-final-price.sql
- calculate-salaries.sql
- calculate-special-bonus.sql
- calculate-the-influence-of-each-salesperson.sql
- calculate-trapping-rain-water.sql
- capital-gainloss.sql
- ceo-subordinate-hierarchy.sql
- change-null-values-in-a-table-to-the-previous-value.sql
- class-performance.sql
- classes-more-than-5-students.sql
- classifying-triangles-by-lengths.sql
- combine-two-tables.sql
- compute-the-rank-as-a-percentage.sql
- concatenate-the-name-and-the-profession.sql
- confirmation-rate.sql
- consecutive-available-seats-ii.sql
- consecutive-available-seats.sql
- consecutive-numbers.sql
- consecutive-transactions-with-increasing-amounts.sql
- convert-date-format.sql
- count-apples-and-oranges.sql
- count-artist-occurrences-on-spotify-ranking-list.sql
- count-occurrences-in-text.sql
- count-salary-categories.sql
- count-student-number-in-departments.sql
- count-the-number-of-experiments.sql
- countries-you-can-safely-invest-in.sql
- create-a-session-bar-chart.sql
- customer-order-frequency.sql
- customer-placing-the-largest-number-of-orders.sql
- customer-purchasing-behavior-analysis.sql
- customer-who-visited-but-did-not-make-any-transactions.sql
- customers-who-bought-all-products.sql
- customers-who-bought-products-a-and-b-but-not-c.sql
- customers-who-never-order.sql
- customers-with-maximum-number-of-transactions-on-consecutive-days.sql
- customers-with-strictly-increasing-purchases.sql
- daily-leads-and-partners.sql
- delete-duplicate-emails.sql
- department-highest-salary.sql
- department-top-three-salaries.sql
- dna-pattern-recognition.sql
- drop-type-1-orders-for-customers-with-type-0-orders.sql
- duplicate-emails.sql
- dynamic-pivoting-of-a-table.sql
- dynamic-unpivoting-of-a-table.sql
- election-results.sql
- employee-bonus.sql
- employee-task-duration-and-concurrent-tasks.sql
- employees-earning-more-than-their-managers.sql
- employees-project-allocation.sql
- employees-whose-manager-left-the-company.sql
- employees-with-deductions.sql
- employees-with-missing-information.sql
- evaluate-boolean-expression.sql
- exchange-seats.sql
- find-active-users.sql
- find-all-unique-email-domains.sql
- find-bursty-behavior.sql
- find-candidates-for-data-scientist-position-ii.sql
- find-candidates-for-data-scientist-position.sql
- find-circular-gift-exchange-chains.sql
- find-cities-in-each-state-ii.sql
- find-cities-in-each-state.sql
- find-cumulative-salary-of-an-employee.sql
- find-customer-referee.sql
- find-customers-with-positive-revenue-this-year.sql
- find-cutoff-score-for-each-school.sql
- find-expensive-cities.sql
- find-followers-count.sql
- find-interview-candidates.sql
- find-invalid-ip-addresses.sql
- find-latest-salaries.sql
- find-longest-calls.sql
- find-median-given-frequency-of-numbers.sql
- find-overlapping-shifts-ii.sql
- find-overlapping-shifts.sql
- find-peak-calling-hours-for-each-city.sql
- find-product-recommendation-pairs.sql
- find-products-with-three-consecutive-digits.sql
- find-products-with-valid-serial-numbers.sql
- find-students-who-improved.sql
- find-the-missing-ids.sql
- find-the-quiet-students-in-all-exams.sql
- find-the-start-and-end-number-of-continuous-ranges.sql
- find-the-subtasks-that-did-not-execute.sql
- find-the-team-size.sql
- find-third-transaction.sql
- find-top-performing-driver.sql
- find-top-scoring-students-ii.sql
- find-top-scoring-students.sql
- find-total-time-spent-by-each-employee.sql
- find-trending-hashtags-ii.sql
- find-trending-hashtags.sql
- find-users-with-valid-e-mails.sql
- find-valid-emails.sql
- finding-the-topic-of-each-post.sql
- first-and-last-call-on-the-same-day.sql
- first-letter-capitalization-ii.sql
- first-letter-capitalization.sql
- fix-names-in-a-table.sql
- fix-product-name-format.sql
- flight-occupancy-and-waitlist-analysis.sql
- form-a-chemical-bond.sql
- friday-purchase-iii.sql
- friday-purchases-i.sql
- friday-purchases-ii.sql
- friend-requests-i-overall-acceptance-rate.sql
- friend-requests-ii-who-has-the-most-friends.sql
- friendly-movies-streamed-last-month.sql
- friends-with-no-mutual-friends.sql
- game-play-analysis-i.sql
- game-play-analysis-ii.sql
- game-play-analysis-iii.sql
- game-play-analysis-iv.sql
- game-play-analysis-v.sql
- generate-the-invoice.sql
- get-highest-answer-rate-question.sql
- get-the-second-most-recent-activity.sql
- grand-slam-titles.sql
- group-employees-of-the-same-salary.sql
- group-sold-products-by-the-date.sql
- highest-grade-for-each-student.sql
- highest-salaries-difference.sql
- hopper-company-queries-i.sql
- hopper-company-queries-ii.sql
- hopper-company-queries-iii.sql
- human-traffic-of-stadium.sql
- immediate-food-delivery-i.sql
- immediate-food-delivery-ii.sql
- immediate-food-delivery-iii.sql
- invalid-tweets-ii.sql
- invalid-tweets.sql
- investments-in-2016.sql
- last-person-to-fit-in-the-elevator.sql
- league-statistics.sql
- leetcodify-friends-recommendations.sql
- leetcodify-similar-friends.sql
- leetflex-banned-accounts.sql
- list-the-products-ordered-in-a-period.sql
- loan-types.sql
- longest-team-pass-streak.sql
- longest-winning-streak.sql
- low-quality-problems.sql
- manager-of-the-largest-department.sql
- managers-with-at-least-5-direct-reports.sql
- market-analysis-i.sql
- market-analysis-ii.sql
- market-analysis-iii.sql
- maximize-items.sql
- maximum-transaction-each-day.sql
- median-employee-salary.sql
- merge-overlapping-events-in-the-same-hall.sql
- monthly-transactions-i.sql
- monthly-transactions-ii.sql
- movie-rating.sql
- new-users-daily-count.sql
- not-boring-movies.sql
- npv-queries.sql
- nth-highest-salary.sql
- number-of-accounts-that-did-not-stream.sql
- number-of-calls-between-two-persons.sql
- number-of-comments-per-post.sql
- number-of-times-a-driver-was-a-passenger.sql
- number-of-transactions-per-visit.sql
- number-of-trusted-contacts-of-a-customer.sql
- number-of-unique-subjects-taught-by-each-teacher.sql
- odd-and-even-transactions.sql
- order-two-columns-independently.sql
- orders-with-maximum-quantity-above-average.sql
- page-recommendations-ii.sql
- page-recommendations.sql
- patients-with-a-condition.sql
- percentage-of-users-attended-a-contest.sql
- pizza-toppings-cost-analysis.sql
- popularity-percentage.sql
- premier-league-table-ranking-ii.sql
- premier-league-table-ranking-iii.sql
- premier-league-table-ranking.sql
- primary-department-for-each-employee.sql
- product-price-at-a-given-date.sql
- product-sales-analysis-i.sql
- product-sales-analysis-ii.sql
- product-sales-analysis-iii.sql
- product-sales-analysis-iv.sql
- product-sales-analysis-v.sql
- products-price-for-each-store.sql
- products-with-three-or-more-orders-in-two-consecutive-years.sql
- products-worth-over-invoices.sql
- project-employees-i.sql
- project-employees-ii.sql
- project-employees-iii.sql
- queries-quality-and-percentage.sql
- rank-scores.sql
- rearrange-products-table.sql
- rectangles-area.sql
- recyclable-and-low-fat-products.sql
- reformat-department-table.sql
- replace-employee-id-with-the-unique-identifier.sql
- report-contiguous-dates.sql
- reported-posts-ii.sql
- reported-posts.sql
- restaurant-growth.sql
- rising-temperature.sql
- rolling-average-steps.sql
- running-total-for-different-genders.sql
- sales-analysis-i.sql
- sales-analysis-ii.sql
- sales-analysis-iii.sql
- sales-by-day-of-the-week.sql
- sales-person.sql
- second-day-verification.sql
- second-degree-follower.sql
- second-highest-salary-ii.sql
- second-highest-salary.sql
- sellers-with-no-sales.sql
- server-utilization-time.sql
- shortest-distance-in-a-line.sql
- shortest-distance-in-a-plane.sql
- snaps-analysis.sql
- sort-the-olympic-table.sql
- status-of-flight-tickets.sql
- strong-friendship.sql
- students-and-examinations.sql
- students-report-by-geography.sql
- students-with-invalid-departments.sql
- suspicious-bank-accounts.sql
- swap-salary.sql
- symmetric-coordinates.sql
- tasks-count-in-the-weekend.sql
- team-dominance-by-pass-success.sql
- team-scores-in-football-tournament.sql
- the-airport-with-the-most-traffic.sql
- the-category-of-each-member-in-the-store.sql
- the-change-in-global-rankings.sql
- the-first-day-of-the-maximum-recorded-degree-in-each-city.sql
- the-latest-login-in-2020.sql
- the-most-frequently-ordered-products-for-each-customer.sql
- the-most-recent-orders-for-each-product.sql
- the-most-recent-three-orders.sql
- the-number-of-employees-which-report-to-each-employee.sql
- the-number-of-passengers-in-each-bus-i.sql
- the-number-of-passengers-in-each-bus-ii.sql
- the-number-of-rich-customers.sql
- the-number-of-seniors-and-juniors-to-join-the-company-ii.sql
- the-number-of-seniors-and-juniors-to-join-the-company.sql
- the-number-of-users-that-are-eligible-for-discount.sql
- the-users-that-are-eligible-for-discount.sql
- the-winner-university.sql
- top-percentile-fraud.sql
- top-three-wineries.sql
- top-travellers.sql
- total-sales-amount-by-year.sql
- total-traveled-distance.sql
- tournament-winners.sql
- tree-node.sql
- triangle-judgement.sql
- trips-and-users.sql
- unique-orders-and-customers-per-month.sql
- unpopular-books.sql
- user-activities-within-time-bounds.sql
- user-activity-for-the-past-30-days-i.sql
- user-activity-for-the-past-30-days-ii.sql
- user-purchase-platform.sql
- users-that-actively-request-confirmation-messages.sql
- users-with-two-purchases-within-seven-days.sql
- viewers-turned-streamers.sql
- warehouse-manager.sql
- weather-type-in-each-country.sql
- winning-candidate.sql
- year-on-year-growth-rate.sql
PHP
Python
Python3
Ruby
Rust
Shell
Swift
TypeScript
.travis.yml
0001-1000.md
1001-2000.md
LICENSE.md
README.md
REFERENCE.md

tree-node.sql

Oct 12, 2018

d39f1ac · Oct 12, 2018