Collapse file tree

Files

 master

/

MySQL

/

Copy path

Directory actions

More options

Directory actions

More options

Failed to load latest commit information.

Latest commit

 Cannot retrieve latest commit at this time.

History

History

 

 

/

MySQL

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
active-businesses.sql		active-businesses.sql
active-users.sql		active-users.sql
activity-participants.sql		activity-participants.sql
actors-and-directors-who-cooperated-at-least-three-times.sql		actors-and-directors-who-cooperated-at-least-three-times.sql
ad-free-sessions.sql		ad-free-sessions.sql
ads-performance.sql		ads-performance.sql
all-people-report-to-the-given-manager.sql		all-people-report-to-the-given-manager.sql
all-the-pairs-with-the-maximum-number-of-common-followers.sql		all-the-pairs-with-the-maximum-number-of-common-followers.sql
all-valid-triplets-that-can-represent-a-country.sql		all-valid-triplets-that-can-represent-a-country.sql
apples-oranges.sql		apples-oranges.sql
article-views-i.sql		article-views-i.sql
article-views-ii.sql		article-views-ii.sql
average-salary-departments-vs-company.sql		average-salary-departments-vs-company.sql
average-selling-price.sql		average-selling-price.sql
average-time-of-process-per-machine.sql		average-time-of-process-per-machine.sql
bank-account-summary-ii.sql		bank-account-summary-ii.sql
bank-account-summary.sql		bank-account-summary.sql
big-countries.sql		big-countries.sql
biggest-single-number.sql		biggest-single-number.sql
biggest-window-between-visits.sql		biggest-window-between-visits.sql
calculate-salaries.sql		calculate-salaries.sql
calculate-special-bonus.sql		calculate-special-bonus.sql
capital-gainloss.sql		capital-gainloss.sql
classes-more-than-5-students.sql		classes-more-than-5-students.sql
combine-two-tables.sql		combine-two-tables.sql
confirmation-rate.sql		confirmation-rate.sql
consecutive-available-seats.sql		consecutive-available-seats.sql
consecutive-numbers.sql		consecutive-numbers.sql
convert-date-format.sql		convert-date-format.sql
count-apples-and-oranges.sql		count-apples-and-oranges.sql
count-salary-categories.sql		count-salary-categories.sql
count-student-number-in-departments.sql		count-student-number-in-departments.sql
count-the-number-of-experiments.sql		count-the-number-of-experiments.sql
countries-you-can-safely-invest-in.sql		countries-you-can-safely-invest-in.sql
create-a-session-bar-chart.sql		create-a-session-bar-chart.sql
customer-order-frequency.sql		customer-order-frequency.sql
customer-placing-the-largest-number-of-orders.sql		customer-placing-the-largest-number-of-orders.sql
customer-who-visited-but-did-not-make-any-transactions.sql		customer-who-visited-but-did-not-make-any-transactions.sql
customers-who-bought-all-products.sql		customers-who-bought-all-products.sql
customers-who-bought-products-a-and-b-but-not-c.sql		customers-who-bought-products-a-and-b-but-not-c.sql
customers-who-never-order.sql		customers-who-never-order.sql
daily-leads-and-partners.sql		daily-leads-and-partners.sql
delete-duplicate-emails.sql		delete-duplicate-emails.sql
department-highest-salary.sql		department-highest-salary.sql
department-top-three-salaries.sql		department-top-three-salaries.sql
duplicate-emails.sql		duplicate-emails.sql
employee-bonus.sql		employee-bonus.sql
employees-earning-more-than-their-managers.sql		employees-earning-more-than-their-managers.sql
employees-whose-manager-left-the-company.sql		employees-whose-manager-left-the-company.sql
employees-with-missing-information.sql		employees-with-missing-information.sql
evaluate-boolean-expression.sql		evaluate-boolean-expression.sql
exchange-seats.sql		exchange-seats.sql
find-cumulative-salary-of-an-employee.sql		find-cumulative-salary-of-an-employee.sql
find-customer-referee.sql		find-customer-referee.sql
find-customers-with-positive-revenue-this-year.sql		find-customers-with-positive-revenue-this-year.sql
find-cutoff-score-for-each-school.sql		find-cutoff-score-for-each-school.sql
find-followers-count.sql		find-followers-count.sql
find-interview-candidates.sql		find-interview-candidates.sql
find-median-given-frequency-of-numbers.sql		find-median-given-frequency-of-numbers.sql
find-the-missing-ids.sql		find-the-missing-ids.sql
find-the-quiet-students-in-all-exams.sql		find-the-quiet-students-in-all-exams.sql
find-the-start-and-end-number-of-continuous-ranges.sql		find-the-start-and-end-number-of-continuous-ranges.sql
find-the-subtasks-that-did-not-execute.sql		find-the-subtasks-that-did-not-execute.sql
find-the-team-size.sql		find-the-team-size.sql
find-total-time-spent-by-each-employee.sql		find-total-time-spent-by-each-employee.sql
find-users-with-valid-e-mails.sql		find-users-with-valid-e-mails.sql
first-and-last-call-on-the-same-day.sql		first-and-last-call-on-the-same-day.sql
fix-names-in-a-table.sql		fix-names-in-a-table.sql
fix-product-name-format.sql		fix-product-name-format.sql
friend-requests-i-overall-acceptance-rate.sql		friend-requests-i-overall-acceptance-rate.sql
friend-requests-ii-who-has-the-most-friends.sql		friend-requests-ii-who-has-the-most-friends.sql
friendly-movies-streamed-last-month.sql		friendly-movies-streamed-last-month.sql
game-play-analysis-i.sql		game-play-analysis-i.sql
game-play-analysis-ii.sql		game-play-analysis-ii.sql
game-play-analysis-iii.sql		game-play-analysis-iii.sql
game-play-analysis-iv.sql		game-play-analysis-iv.sql
game-play-analysis-v.sql		game-play-analysis-v.sql
get-highest-answer-rate-question.sql		get-highest-answer-rate-question.sql
get-the-second-most-recent-activity.sql		get-the-second-most-recent-activity.sql
grand-slam-titles.sql		grand-slam-titles.sql
group-employees-of-the-same-salary.sql		group-employees-of-the-same-salary.sql
group-sold-products-by-the-date.sql		group-sold-products-by-the-date.sql
highest-grade-for-each-student.sql		highest-grade-for-each-student.sql
hopper-company-queries-i.sql		hopper-company-queries-i.sql
hopper-company-queries-ii.sql		hopper-company-queries-ii.sql
hopper-company-queries-iii.sql		hopper-company-queries-iii.sql
human-traffic-of-stadium.sql		human-traffic-of-stadium.sql
immediate-food-delivery-i.sql		immediate-food-delivery-i.sql
immediate-food-delivery-ii.sql		immediate-food-delivery-ii.sql
invalid-tweets.sql		invalid-tweets.sql
investments-in-2016.sql		investments-in-2016.sql
last-person-to-fit-in-the-elevator.sql		last-person-to-fit-in-the-elevator.sql
league-statistics.sql		league-statistics.sql
leetcodify-friends-recommendations.sql		leetcodify-friends-recommendations.sql
leetcodify-similar-friends.sql		leetcodify-similar-friends.sql
leetflex-banned-accounts.sql		leetflex-banned-accounts.sql
list-the-products-ordered-in-a-period.sql		list-the-products-ordered-in-a-period.sql
low-quality-problems.sql		low-quality-problems.sql
managers-with-at-least-5-direct-reports.sql		managers-with-at-least-5-direct-reports.sql
market-analysis-i.sql		market-analysis-i.sql
market-analysis-ii.sql		market-analysis-ii.sql
maximum-transaction-each-day.sql		maximum-transaction-each-day.sql
median-employee-salary.sql		median-employee-salary.sql
monthly-transactions-i.sql		monthly-transactions-i.sql
monthly-transactions-ii.sql		monthly-transactions-ii.sql
movie-rating.sql		movie-rating.sql
new-users-daily-count.sql		new-users-daily-count.sql
not-boring-movies.sql		not-boring-movies.sql
npv-queries.sql		npv-queries.sql
nth-highest-salary.sql		nth-highest-salary.sql
number-of-accounts-that-did-not-stream.sql		number-of-accounts-that-did-not-stream.sql
number-of-calls-between-two-persons.sql		number-of-calls-between-two-persons.sql
number-of-comments-per-post.sql		number-of-comments-per-post.sql
number-of-transactions-per-visit.sql		number-of-transactions-per-visit.sql
number-of-trusted-contacts-of-a-customer.sql		number-of-trusted-contacts-of-a-customer.sql
orders-with-maximum-quantity-above-average.sql		orders-with-maximum-quantity-above-average.sql
page-recommendations-ii.sql		page-recommendations-ii.sql
page-recommendations.sql		page-recommendations.sql
patients-with-a-condition.sql		patients-with-a-condition.sql
percentage-of-users-attended-a-contest.sql		percentage-of-users-attended-a-contest.sql
primary-department-for-each-employee.sql		primary-department-for-each-employee.sql
product-price-at-a-given-date.sql		product-price-at-a-given-date.sql
product-sales-analysis-i.sql		product-sales-analysis-i.sql
product-sales-analysis-ii.sql		product-sales-analysis-ii.sql
product-sales-analysis-iii.sql		product-sales-analysis-iii.sql
products-price-for-each-store.sql		products-price-for-each-store.sql
products-worth-over-invoices.sql		products-worth-over-invoices.sql
project-employees-i.sql		project-employees-i.sql
project-employees-ii.sql		project-employees-ii.sql
project-employees-iii.sql		project-employees-iii.sql
queries-quality-and-percentage.sql		queries-quality-and-percentage.sql
rank-scores.sql		rank-scores.sql
rearrange-products-table.sql		rearrange-products-table.sql
rectangles-area.sql		rectangles-area.sql
recyclable-and-low-fat-products.sql		recyclable-and-low-fat-products.sql
reformat-department-table.sql		reformat-department-table.sql
replace-employee-id-with-the-unique-identifier.sql		replace-employee-id-with-the-unique-identifier.sql
report-contiguous-dates.sql		report-contiguous-dates.sql
reported-posts-ii.sql		reported-posts-ii.sql
reported-posts.sql		reported-posts.sql
restaurant-growth.sql		restaurant-growth.sql
rising-temperature.sql		rising-temperature.sql
running-total-for-different-genders.sql		running-total-for-different-genders.sql
sales-analysis-i.sql		sales-analysis-i.sql
sales-analysis-ii.sql		sales-analysis-ii.sql
sales-analysis-iii.sql		sales-analysis-iii.sql
sales-by-day-of-the-week.sql		sales-by-day-of-the-week.sql
sales-person.sql		sales-person.sql
second-degree-follower.sql		second-degree-follower.sql
second-highest-salary.sql		second-highest-salary.sql
sellers-with-no-sales.sql		sellers-with-no-sales.sql
shortest-distance-in-a-line.sql		shortest-distance-in-a-line.sql
shortest-distance-in-a-plane.sql		shortest-distance-in-a-plane.sql
strong-friendship.sql		strong-friendship.sql
students-and-examinations.sql		students-and-examinations.sql
students-report-by-geography.sql		students-report-by-geography.sql
students-with-invalid-departments.sql		students-with-invalid-departments.sql
suspicious-bank-accounts.sql		suspicious-bank-accounts.sql
swap-salary.sql		swap-salary.sql
team-scores-in-football-tournament.sql		team-scores-in-football-tournament.sql
the-latest-login-in-2020.sql		the-latest-login-in-2020.sql
the-most-frequently-ordered-products-for-each-customer.sql		the-most-frequently-ordered-products-for-each-customer.sql
the-most-recent-orders-for-each-product.sql		the-most-recent-orders-for-each-product.sql
the-most-recent-three-orders.sql		the-most-recent-three-orders.sql
the-number-of-employees-which-report-to-each-employee.sql		the-number-of-employees-which-report-to-each-employee.sql
the-number-of-seniors-and-juniors-to-join-the-company-ii.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-seniors-and-juniors-to-join-the-company.sql
top-travellers.sql		top-travellers.sql
total-sales-amount-by-year.sql		total-sales-amount-by-year.sql
tournament-winners.sql		tournament-winners.sql
tree-node.sql		tree-node.sql
triangle-judgement.sql		triangle-judgement.sql
trips-and-users.sql		trips-and-users.sql
unique-orders-and-customers-per-month.sql		unique-orders-and-customers-per-month.sql
unpopular-books.sql		unpopular-books.sql
user-activity-for-the-past-30-days-i.sql		user-activity-for-the-past-30-days-i.sql
user-activity-for-the-past-30-days-ii.sql		user-activity-for-the-past-30-days-ii.sql
user-purchase-platform.sql		user-purchase-platform.sql
users-that-actively-request-confirmation-messages.sql		users-that-actively-request-confirmation-messages.sql
warehouse-manager.sql		warehouse-manager.sql
weather-type-in-each-country.sql		weather-type-in-each-country.sql
winning-candidate.sql		winning-candidate.sql
View all files