accepted-candidates-from-the-interviews.sql
activity-participants.sql
actors-and-directors-who-cooperated-at-least-three-times.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
arrange-table-by-gender.sql
average-salary-departments-vs-company.sql
average-selling-price.sql
average-time-of-process-per-machine.sql
bank-account-summary-ii.sql
biggest-single-number.sql
biggest-window-between-visits.sql
bitwise-user-permissions-analysis.sql
books-with-null-ratings.sql
calculate-compressed-mean.sql
calculate-orders-within-each-interval.sql
calculate-parking-fees-and-duration.sql
calculate-product-final-price.sql
calculate-special-bonus.sql
calculate-the-influence-of-each-salesperson.sql
calculate-trapping-rain-water.sql
ceo-subordinate-hierarchy.sql
change-null-values-in-a-table-to-the-previous-value.sql
classes-more-than-5-students.sql
classifying-triangles-by-lengths.sql
compute-the-rank-as-a-percentage.sql
concatenate-the-name-and-the-profession.sql
consecutive-available-seats-ii.sql
consecutive-available-seats.sql
consecutive-transactions-with-increasing-amounts.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
dynamic-pivoting-of-a-table.sql
dynamic-unpivoting-of-a-table.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
find-all-unique-email-domains.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-interview-candidates.sql
find-invalid-ip-addresses.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-products-with-three-consecutive-digits.sql
find-products-with-valid-serial-numbers.sql
find-students-who-improved.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-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
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-product-name-format.sql
flight-occupancy-and-waitlist-analysis.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-ii.sql
game-play-analysis-iii.sql
game-play-analysis-iv.sql
get-highest-answer-rate-question.sql
get-the-second-most-recent-activity.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
last-person-to-fit-in-the-elevator.sql
leetcodify-friends-recommendations.sql
leetcodify-similar-friends.sql
leetflex-banned-accounts.sql
list-the-products-ordered-in-a-period.sql
longest-team-pass-streak.sql
longest-winning-streak.sql
manager-of-the-largest-department.sql
managers-with-at-least-5-direct-reports.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
new-users-daily-count.sql
number-of-accounts-that-did-not-stream.sql
number-of-calls-between-two-persons.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
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-iii.sql
queries-quality-and-percentage.sql
rearrange-products-table.sql
recyclable-and-low-fat-products.sql
reformat-department-table.sql
replace-employee-id-with-the-unique-identifier.sql
report-contiguous-dates.sql
rolling-average-steps.sql
running-total-for-different-genders.sql
sales-by-day-of-the-week.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
sort-the-olympic-table.sql
status-of-flight-tickets.sql
students-and-examinations.sql
students-report-by-geography.sql
students-with-invalid-departments.sql
suspicious-bank-accounts.sql
symmetric-coordinates.sql
tasks-count-in-the-weekend.sql
team-dominance-by-pass-success.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
total-sales-amount-by-year.sql
total-traveled-distance.sql
unique-orders-and-customers-per-month.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
weather-type-in-each-country.sql
year-on-year-growth-rate.sql
Folders and files Name Name Last commit message
Last commit date
parent directory
View all files
You can’t perform that action at this time.