Files

00175-combine-two-tables.sql
00176-second-highest-salary.sql
00177-nth-highest-salary.sql
00178-rank-scores.sql
00180-consecutive-numbers.sql
00181-employees-earning-more-than-their-managers.sql
00182-duplicate-emails.sql
00183-customers-who-never-order.sql
00184-department-highest-salary.sql
00185-department-top-three-salaries.sql
00196-delete-duplicate-emails.sql
00197-rising-temperature.sql
00262-trips-and-users.sql
00511-game-play-analysis-i.sql
00512-game-play-analysis-ii.sql
00534-game-play-analysis-iii.sql
00550-game-play-analysis-iv.sql
00569-median-employee-salary.sql
00570-managers-with-at-least-5-direct-reports.sql
00571-find-median-given-frequency-of-numbers.sql
00574-winning-candidate.sql
00577-employee-bonus.sql
00578-get-highest-answer-rate-question.sql
00579-find-cumulative-salary-of-an-employee.sql
00580-count-student-number-in-departments.sql
00584-find-customer-referee.sql
00585-investments-in-2016.sql
00586-customer-placing-the-largest-number-of-orders.sql
00595-big-countries.sql
00596-classes-more-than-5-students.sql
00597-friend-requests-i-overall-acceptance-rate.sql
00601-human-traffic-of-stadium.sql
00602-friend-requests-ii-who-has-the-most-friends.sql
00603-consecutive-available-seats.sql
00607-sales-person.sql
00608-tree-node.sql
00610-triangle-judgement.sql
00612-shortest-distance-in-a-plane.sql
00613-shortest-distance-in-a-line.sql
00614-second-degree-follower.sql
00615-average-salary-departments-vs-company.sql
00618-students-reported-by-geography.sql
00619-biggest-single-number.sql
00620-not-boring-movies.sql
00626-exchange-seats.sql
00627-swap-salary.sql
01045-customers-who-bought-all-products.sql
01050-actors-and-director-who-cooperated-at-least-three-times.sql
01068-product-sales-analysis-i.sql
01069-prooduct-sales-analysis-ii.sql
01070-product-sales-analysis-iii.sql
01075-project-employees-i.sql
01076-project-employees-ii.sql
01077-project-employees-iii.sql
01082-sales-analysis-i.sql
01083-sales-analysis-ii.sql
01084-sales-analysis-iii.sql
01097-game-play-analysis-v.sql
01098-unpopular-books.sql
01107-new-users-daily-count.sql
01112-highest-grade-for-each-student.sql
01113-reported-posts.sql
01126-active-businesses.sql
01127-user-purchase-platform.sql
01132-reported-posts-ii.sql
01141-user-activity-for-the-past-30-days-i.sql
01142-user-activity-for-the-past-30-days-ii.sql
01148-article-views-i.sql
01149-article-views-ii.sql
01158-market-analysis-i.sql
01159-market-analysis-ii.sql
01164-product-price-at-a-given-date.sql
01173-immediate-food-delivery-i.sql
01174-immediate-food-delivery-ii.sql
01179-reformat-department-table.sql
01193-monthly-transactions-i.sql
01194-tournament-winners.sql
01204-last-person-to-fit-in-the-bus.sql
01205-monthly-tractions-ii.sql
01211-queries-quality-and-percentage.sql
01212-teams-scores-in-football-tournamant.sql
01225-report-contiguous-dates.sql
01241-number-of-comments-per-post.sql
01251-average-selling-price.sql
01264-page-recommendations.sql
01270-all-people-report-to-the-given-manager.sql
01280-students-and-examinations.sql
01285-find-the-start-and-end-number-of-continuous-ranges.sql
01294-weather-type-in-each-country.sql
01303-find-the-team-size.sql
01308-running-total-for-different-genders.sql
01321-restaurant-growth.sql
01322-ads-performance.sql
01327-list-the-products-ordered-in-a-period.sql
01336-number-of-transactions-per-visit.sql
01341-movie-rating.sql
01350-students-with-invalid-departments.sql
01355-activity-participans.sql
01364-number-of-trusted-contacts-of-a-customer.sql
01369-get-the-second-most-recent-ctivity.sql
01378-replace-employee-id-with-the-unique-identifier.sql
01384-total-sales-amount-by-year.sql
01393-capital-gain-loss.sql
01398-customers-who-bought-products-A-and-B-but-not-C.sql
01407-top-travellers.sql
01412-find-the-quiet-students-in-all-exams.sql
01421-npv-queries.sql
01435-create-a-sessions-bar-chart.sql
01440-evaluate-boolean-expression.sql
01445-apples-&-oranges.sql
01454-active-users.sql
01459-rectangles-area.sql
01468- calculate-salaries.sql
01479-sales-by-day-of-the-week.sql
01484-group-sold-products-by-the-date.sql
01495-friendly-movies-streamed-last-month.sql
01501-countries-you-can-safely-invest-in.sql
01511-customer_order-frequency.sql
01517-find-users-with-valid-emails.sql
01527-patients-with-a-condition.sql
01532-the-most-recent-three-orders.sql
01543-fix-product-name-format.sql
01549-the-most-recent-orders-for-each-product.sql
01555-bank-account-summary.sql
01565-unique-orders-and-customers-per-month.sql
01571-warehouse-manager.sql
01581-customer-who-visited-but-did-not-make-any-transactions.sql
01587-bank-account-summary-ii.sql
01596-the-most-frequently-ordered-products-for-each-customer.sql
01607-sellers-with-no-sales.sql
01613-find-the-missing-ids.sql
01623-all-valid-triplets-that-can-represent-a-country.sql
01633-percentage-of-users-attended-a-contest.sql
01635-hopper-company-queries-i.sql
01661-average-time-of-process-per-machine.sql
01667-fix-names-in-a-table.sql
01677-products-worth-over-invoices.sql
01683-invalid-tweets.sql
01693-daily_leads-and-partners.sql
01699-number-of-calls-between-two-persons.sql
01709-biggest-window-between-visits.sql
01715-count-apples-and-oranges.sql
01729-find-followers-count.sql
01731-the-number-of-employees-which-report-to-each-employee.sql
01741-find-total-time-spent-by-each-employee.sql
01747-leetflex-banned-accounts.sql
01757-recyclable-and-low-fat-products.sql
01767-find-the-subtasks-that-did-not-execute.sql
01777-products-price-for-each-store.sql
01783-grand-slam-titles.sql
01789-primary-department-for-each-employee.sql
01795-rearrange-products-table.sql
01809-ad-free-sessions.sql
01811-find-interview-candidates.sql
01821-find-customers-with-positive-revenue-this-year.sql
01831-maximum-transaction-each-day.sql
01841-league-statistics.sql
01853-convert-date-format.sql
01867-orders-with-maximum-quantity-above-average.sql
01873-calculate-special-bonus.sql
01875-group-employees-of-the-same-salary.sql
01890-the-latest-login-in-2020.sql
01907-count-salary-categories.sql
01934-confirmation-rate.sql
01939-users-that-actively-request-confirmation-messages.sql
01949-strong-friendship.sql
01951-all-the-pairs-with-the-maximum-number-of-common-followers.sql
01965-employees-with-missing-information.sql
01972-first-and-last-call-on-the-same-day.sql
01978-employees-whose-manager-left-the-company.sql
01988-find-cutoff-score-for-each-school.sql
01990-count-the-number-of-experiments.sql
02004-the-number-of-seniors-and-juniors-to-join-the-company.sql
02010-the-number-of-seniors-and-juniors-to-join-the-company-ii.sql
02020-number-of-accounts-that-did-not-stream.sql
02026-low-quality-problems.sql
02041-accepted-candidates-from-the-interviews.sql
02066-account-balance.sql
02072-the-winner-university.sql
02082-the-number-of-rich-customers.sql
02084-drop-type-1-orders-for-customers-with-type-0-orders.sql
02112-the-airport-with-the-most-traffic.sql
02118-build-the-equation.sql
02142-the-number-of-passengers-in-each-bus-i.sql
02159- order-two-columns-independently.sql
02173-longest-winning-streak.sql
02175-the-change-in-global-rankings.sql
02199-finding-the-topic-of-each-post.sql
02205-the-number-of-users-that-are-eligible-for-the-discount.sql
02228-user-with-two-purchases-within-seven-days.sql
02230-the-users-that-are-eligible-for-discount.sql
02308-arrange-table-by-gender.sql
02356-number-of-unique-subjects-taught-by-each-teacher.sql
02377-sort-the-olympic-table.sql
02668-find-latest-salaries.sql
02701-consecutive-transactions-with-increasing-amounts.sql
Patterns
README.md

00175-combine-two-tables.sql

Add files via upload

Jan 27, 2024

9b23f08 · Jan 27, 2024