Skip to content

Latest commit

 

History

History

Easy

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
00175-combine-two-tables.sql
00175-combine-two-tables.sql
 
 
00181-employees-earning-more-than-their-managers.sql
00181-employees-earning-more-than-their-managers.sql
 
 
00182-duplicate-emails.sql
00182-duplicate-emails.sql
 
 
00183-customers-who-never-order.sql
00183-customers-who-never-order.sql
 
 
00196-delete-duplicate-emails.sql
00196-delete-duplicate-emails.sql
 
 
00197-rising-temperature.sql
00197-rising-temperature.sql
 
 
00511-game-play-analysis-i.sql
00511-game-play-analysis-i.sql
 
 
00512-game-play-analysis-ii.sql
00512-game-play-analysis-ii.sql
 
 
00577-employee-bonus.sql
00577-employee-bonus.sql
 
 
00584-find-customer-referee.sql
00584-find-customer-referee.sql
 
 
00586-customer-placing-the-largest-number-of-orders.sql
00586-customer-placing-the-largest-number-of-orders.sql
 
 
00595-big-countries.sql
00595-big-countries.sql
 
 
00596-classes-more-than-5-students.sql
00596-classes-more-than-5-students.sql
 
 
00597-friend-requests-i-overall-acceptance-rate.sql
00597-friend-requests-i-overall-acceptance-rate.sql
 
 
00603-consecutive-available-seats.sql
00603-consecutive-available-seats.sql
 
 
00607-sales-person.sql
00607-sales-person.sql
 
 
00610-triangle-judgement.sql
00610-triangle-judgement.sql
 
 
00613-shortest-distance-in-a-line.sql
00613-shortest-distance-in-a-line.sql
 
 
00619-biggest-single-number.sql
00619-biggest-single-number.sql
 
 
00620-not-boring-movies.sql
00620-not-boring-movies.sql
 
 
00627-swap-salary.sql
00627-swap-salary.sql
 
 
01050-actors-and-director-who-cooperated-at-least-three-times.sql
01050-actors-and-director-who-cooperated-at-least-three-times.sql
 
 
01068-product-sales-analysis-i.sql
01068-product-sales-analysis-i.sql
 
 
01069-prooduct-sales-analysis-ii.sql
01069-prooduct-sales-analysis-ii.sql
 
 
01075-project-employees-i.sql
01075-project-employees-i.sql
 
 
01076-project-employees-ii.sql
01076-project-employees-ii.sql
 
 
01082-sales-analysis-i.sql
01082-sales-analysis-i.sql
 
 
01083-sales-analysis-ii.sql
01083-sales-analysis-ii.sql
 
 
01084-sales-analysis-iii.sql
01084-sales-analysis-iii.sql
 
 
01113-reported-posts.sql
01113-reported-posts.sql
 
 
01141-user-activity-for-the-past-30-days-i.sql
01141-user-activity-for-the-past-30-days-i.sql
 
 
01142-user-activity-for-the-past-30-days-ii.sql
01142-user-activity-for-the-past-30-days-ii.sql
 
 
01148-article-views-i.sql
01148-article-views-i.sql
 
 
01173-immediate-food-delivery-i.sql
01173-immediate-food-delivery-i.sql
 
 
01179-reformat-department-table.sql
01179-reformat-department-table.sql
 
 
01211-queries-quality-and-percentage.sql
01211-queries-quality-and-percentage.sql
 
 
01241-number-of-comments-per-post.sql
01241-number-of-comments-per-post.sql
 
 
01251-average-selling-price.sql
01251-average-selling-price.sql
 
 
01280-students-and-examinations.sql
01280-students-and-examinations.sql
 
 
01294-weather-type-in-each-country.sql
01294-weather-type-in-each-country.sql
 
 
01303-find-the-team-size.sql
01303-find-the-team-size.sql
 
 
01322-ads-performance.sql
01322-ads-performance.sql
 
 
01327-list-the-products-ordered-in-a-period.sql
01327-list-the-products-ordered-in-a-period.sql
 
 
01350-students-with-invalid-departments.sql
01350-students-with-invalid-departments.sql
 
 
01378-replace-employee-id-with-the-unique-identifier.sql
01378-replace-employee-id-with-the-unique-identifier.sql
 
 
01407-top-travellers.sql
01407-top-travellers.sql
 
 
01421-npv-queries.sql
01421-npv-queries.sql
 
 
01435-create-a-sessions-bar-chart.sql
01435-create-a-sessions-bar-chart.sql
 
 
01484-group-sold-products-by-the-date.sql
01484-group-sold-products-by-the-date.sql
 
 
01495-friendly-movies-streamed-last-month.sql
01495-friendly-movies-streamed-last-month.sql
 
 
01511-customer_order-frequency.sql
01511-customer_order-frequency.sql
 
 
01517-find-users-with-valid-emails.sql
01517-find-users-with-valid-emails.sql
 
 
01527-patients-with-a-condition.sql
01527-patients-with-a-condition.sql
 
 
01543-fix-product-name-format.sql
01543-fix-product-name-format.sql
 
 
01565-unique-orders-and-customers-per-month.sql
01565-unique-orders-and-customers-per-month.sql
 
 
01571-warehouse-manager.sql
01571-warehouse-manager.sql
 
 
01581-customer-who-visited-but-did-not-make-any-transactions.sql
01581-customer-who-visited-but-did-not-make-any-transactions.sql
 
 
01587-bank-account-summary-ii.sql
01587-bank-account-summary-ii.sql
 
 
01607-sellers-with-no-sales.sql
01607-sellers-with-no-sales.sql
 
 
01623-all-valid-triplets-that-can-represent-a-country.sql
01623-all-valid-triplets-that-can-represent-a-country.sql
 
 
01633-percentage-of-users-attended-a-contest.sql
01633-percentage-of-users-attended-a-contest.sql
 
 
01661-average-time-of-process-per-machine.sql
01661-average-time-of-process-per-machine.sql
 
 
01667-fix-names-in-a-table.sql
01667-fix-names-in-a-table.sql
 
 
01677-products-worth-over-invoices.sql
01677-products-worth-over-invoices.sql
 
 
01683-invalid-tweets.sql
01683-invalid-tweets.sql
 
 
01693-daily_leads-and-partners.sql
01693-daily_leads-and-partners.sql
 
 
01729-find-followers-count.sql
01729-find-followers-count.sql
 
 
01731-the-number-of-employees-which-report-to-each-employee.sql
01731-the-number-of-employees-which-report-to-each-employee.sql
 
 
01741-find-total-time-spent-by-each-employee.sql
01741-find-total-time-spent-by-each-employee.sql
 
 
01757-recyclable-and-low-fat-products.sql
01757-recyclable-and-low-fat-products.sql
 
 
01777-products-price-for-each-store.sql
01777-products-price-for-each-store.sql
 
 
01789-primary-department-for-each-employee.sql
01789-primary-department-for-each-employee.sql
 
 
01795-rearrange-products-table.sql
01795-rearrange-products-table.sql
 
 
01809-ad-free-sessions.sql
01809-ad-free-sessions.sql
 
 
01821-find-customers-with-positive-revenue-this-year.sql
01821-find-customers-with-positive-revenue-this-year.sql
 
 
01853-convert-date-format.sql
01853-convert-date-format.sql
 
 
01873-calculate-special-bonus.sql
01873-calculate-special-bonus.sql
 
 
01890-the-latest-login-in-2020.sql
01890-the-latest-login-in-2020.sql
 
 
01939-users-that-actively-request-confirmation-messages.sql
01939-users-that-actively-request-confirmation-messages.sql
 
 
01965-employees-with-missing-information.sql
01965-employees-with-missing-information.sql
 
 
01978-employees-whose-manager-left-the-company.sql
01978-employees-whose-manager-left-the-company.sql
 
 
02026-low-quality-problems.sql
02026-low-quality-problems.sql
 
 
02072-the-winner-university.sql
02072-the-winner-university.sql
 
 
02082-the-number-of-rich-customers.sql
02082-the-number-of-rich-customers.sql
 
 
02205-the-number-of-users-that-are-eligible-for-the-discount.sql
02205-the-number-of-users-that-are-eligible-for-the-discount.sql
 
 
02230-the-users-that-are-eligible-for-discount.sql
02230-the-users-that-are-eligible-for-discount.sql
 
 
02356-number-of-unique-subjects-taught-by-each-teacher.sql
02356-number-of-unique-subjects-taught-by-each-teacher.sql
 
 
02377-sort-the-olympic-table.sql
02377-sort-the-olympic-table.sql
 
 
02668-find-latest-salaries.sql
02668-find-latest-salaries.sql
 
 
close