Collapse file tree

Files

 master

/

MySQL

/

Copy path

Directory actions

More options

More options

Directory actions

More options

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
ads-performance.sql		ads-performance.sql
all-people-report-to-the-given-manager.sql		all-people-report-to-the-given-manager.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
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
calculate-salaries.sql		calculate-salaries.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
consecutive-available-seats.sql		consecutive-available-seats.sql
consecutive-numbers.sql		consecutive-numbers.sql
count-student-number-in-department.sql		count-student-number-in-department.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
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
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-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-team-size.sql		find-the-team-size.sql
find-users-with-valid-e-mails.sql		find-users-with-valid-e-mails.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
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
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
investments-in-2016.sql		investments-in-2016.sql
last-person-to-fit-in-the-elevator.sql		last-person-to-fit-in-the-elevator.sql
list-the-products-ordered-in-a-period.sql		list-the-products-ordered-in-a-period.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
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-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
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
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
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
rectangles-area.sql		rectangles-area.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
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
swap-salary.sql		swap-salary.sql
team-scores-in-football-tournament.sql		team-scores-in-football-tournament.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
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
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