https://www.sql-practice.online/scenario 2026-08-08 https://www.sql-practice.online/scenario/aggregations https://www.sql-practice.online/scenario/aggregations/department-payroll-contribution https://www.sql-practice.online/scenario/aggregations/exact-vs-approximate-customer-reach https://www.sql-practice.online/scenario/aggregations/governed-monthly-kpi-table https://www.sql-practice.online/scenario/aggregations/monthly-order-value-trend https://www.sql-practice.online/scenario/aggregations/order-status-scorecard https://www.sql-practice.online/scenario/aggregations/order-value-metric-snapshot https://www.sql-practice.online/scenario/aggregations/recurring-february-event-types https://www.sql-practice.online/scenario/aggregations/regional-category-order-mix https://www.sql-practice.online/scenario/aggregations/regional-order-coverage https://www.sql-practice.online/scenario/aggregations/regional-order-value-baseline https://www.sql-practice.online/scenario/aggregations/regional-order-value-distribution https://www.sql-practice.online/scenario/aggregations/regional-revenue-rollup https://www.sql-practice.online/scenario/aggregations/regional-weighted-selling-price https://www.sql-practice.online/scenario/aggregations/repair-category-summary-grain https://www.sql-practice.online/scenario/aggregations/revenue-without-join-fan-out https://www.sql-practice.online/scenario/aggregations/unique-business-event-count https://www.sql-practice.online/scenario/basic-functions https://www.sql-practice.online/scenario/basic-functions/assign-deterministic-modulo-shards https://www.sql-practice.online/scenario/basic-functions/build-a-null-safe-display-name https://www.sql-practice.online/scenario/basic-functions/calculate-a-divide-by-zero-safe-rate https://www.sql-practice.online/scenario/basic-functions/choose-the-first-usable-contact https://www.sql-practice.online/scenario/basic-functions/find-and-trim-padded-emails https://www.sql-practice.online/scenario/basic-functions/measure-unicode-labels-by-character https://www.sql-practice.online/scenario/basic-functions/normalize-mixed-phone-punctuation https://www.sql-practice.online/scenario/basic-functions/parse-valid-email-components https://www.sql-practice.online/scenario/basic-functions/rank-absolute-target-deviations https://www.sql-practice.online/scenario/basic-functions/round-a-completion-percentage https://www.sql-practice.online/scenario/basic-functions/safely-convert-dirty-quantity-text https://www.sql-practice.online/scenario/basic-functions/standardize-mixed-case-names https://www.sql-practice.online/scenario/basic-functions/use-substring-for-a-fixed-width-batch-prefix https://www.sql-practice.online/scenario/case-statements https://www.sql-practice.online/scenario/case-statements/apply-first-match-incident-priority https://www.sql-practice.online/scenario/case-statements/bucket-latency-at-exact-sla-boundaries https://www.sql-practice.online/scenario/case-statements/build-a-precedence-safe-operations-work-queue https://www.sql-practice.online/scenario/case-statements/classify-pipeline-health-with-searched-case https://www.sql-practice.online/scenario/case-statements/combine-boolean-rules-into-a-response-action https://www.sql-practice.online/scenario/case-statements/combine-simple-case-and-searched-case-points https://www.sql-practice.online/scenario/case-statements/compose-case-expressions-into-a-risk-score https://www.sql-practice.online/scenario/case-statements/distinguish-null-ownership-from-named-teams https://www.sql-practice.online/scenario/case-statements/emit-reusable-data-quality-flags https://www.sql-practice.online/scenario/case-statements/guard-a-conditional-failure-rate-calculation https://www.sql-practice.online/scenario/case-statements/map-pipeline-status-codes-with-simple-case https://www.sql-practice.online/scenario/case-statements/model-a-four-state-sla-outcome https://www.sql-practice.online/scenario/case-statements/route-incidents-with-nested-case https://www.sql-practice.online/scenario/ctes-window https://www.sql-practice.online/scenario/ctes-window/broadcast-starting-and-latest-revenue-with-full-frames https://www.sql-practice.online/scenario/ctes-window/calculate-a-deterministic-running-revenue-total https://www.sql-practice.online/scenario/ctes-window/calculate-period-over-period-revenue-growth https://www.sql-practice.online/scenario/ctes-window/compare-each-period-with-its-neighbors https://www.sql-practice.online/scenario/ctes-window/compare-team-revenue-with-a-chained-cte-pipeline https://www.sql-practice.online/scenario/ctes-window/contrast-physical-and-peer-aware-running-totals https://www.sql-practice.online/scenario/ctes-window/detect-consecutive-reporting-streaks https://www.sql-practice.online/scenario/ctes-window/keep-the-latest-snapshot-per-team https://www.sql-practice.online/scenario/ctes-window/measure-cumulative-revenue-concentration https://www.sql-practice.online/scenario/ctes-window/select-the-best-quality-snapshot-per-team https://www.sql-practice.online/scenario/ctes-window/summarize-team-performance-with-a-cte https://www.sql-practice.online/scenario/database-changes https://www.sql-practice.online/scenario/database-changes/add-a-new-customer-account https://www.sql-practice.online/scenario/database-changes/add-and-backfill-account-risk https://www.sql-practice.online/scenario/database-changes/commit-a-coordinated-account-upgrade https://www.sql-practice.online/scenario/database-changes/create-an-account-notes-table https://www.sql-practice.online/scenario/database-changes/escalate-pending-orders-safely https://www.sql-practice.online/scenario/database-changes/index-the-account-order-lookup https://www.sql-practice.online/scenario/database-changes/publish-an-active-account-view https://www.sql-practice.online/scenario/database-changes/remove-expired-cancelled-orders https://www.sql-practice.online/scenario/database-changes/roll-back-a-rejected-account-closure https://www.sql-practice.online/scenario/database-changes/upsert-a-retry-safe-account-sync https://www.sql-practice.online/scenario/date-operations https://www.sql-practice.online/scenario/date-operations/build-a-dense-7-calendar-day-moving-average https://www.sql-practice.online/scenario/date-operations/busiest-day-of-the-week https://www.sql-practice.online/scenario/date-operations/calculate-a-7-observed-day-moving-average https://www.sql-practice.online/scenario/date-operations/calculate-completed-employee-tenure-years https://www.sql-practice.online/scenario/date-operations/calculate-days-between-order-and-shipping https://www.sql-practice.online/scenario/date-operations/calculate-may-2024-month-to-date-revenue https://www.sql-practice.online/scenario/date-operations/calculate-year-to-date-ytd-sales-by-month https://www.sql-practice.online/scenario/date-operations/compare-consecutive-active-weeks https://www.sql-practice.online/scenario/date-operations/compare-like-for-like-year-over-year-months https://www.sql-practice.online/scenario/date-operations/cumulative-sum-with-monthly-reset https://www.sql-practice.online/scenario/date-operations/customer-first-order-last-order-and-lifespan https://www.sql-practice.online/scenario/date-operations/customer-value-by-first-purchase-cohort https://www.sql-practice.online/scenario/date-operations/days-between-consecutive-orders-per-customer https://www.sql-practice.online/scenario/date-operations/employee-tenure-in-years-and-months https://www.sql-practice.online/scenario/date-operations/extract-month-and-year-from-order-date https://www.sql-practice.online/scenario/date-operations/filter-a-half-open-timestamp-window https://www.sql-practice.online/scenario/date-operations/find-active-customers-in-last-30-days https://www.sql-practice.online/scenario/date-operations/first-purchase-cohort-retention-by-month https://www.sql-practice.online/scenario/date-operations/fiscal-quarter-segmentation https://www.sql-practice.online/scenario/date-operations/monthly-revenue-summary-portable-month-bucketing https://www.sql-practice.online/scenario/date-operations/quarter-over-quarter-qoq-sales-growth https://www.sql-practice.online/scenario/date-operations/rank-the-busiest-transaction-hours https://www.sql-practice.online/scenario/date-operations/segment-customers-by-order-recency https://www.sql-practice.online/scenario/date-operations/shipping-sla-breach-slower-than-3-days https://www.sql-practice.online/scenario/date-operations/time-to-first-repeat-purchase https://www.sql-practice.online/scenario/date-operations/weekend-vs-weekday-revenue-split https://www.sql-practice.online/scenario/finding-duplicates https://www.sql-practice.online/scenario/finding-duplicates/build-a-data-quality-control-scorecard https://www.sql-practice.online/scenario/finding-duplicates/compare-non-survivors-with-the-approved-record https://www.sql-practice.online/scenario/finding-duplicates/count-quality-defects-per-record https://www.sql-practice.online/scenario/finding-duplicates/detect-duplicate-composite-source-ids https://www.sql-practice.online/scenario/finding-duplicates/find-duplicates-after-email-normalization https://www.sql-practice.online/scenario/finding-duplicates/find-orphan-account-references-safely https://www.sql-practice.online/scenario/finding-duplicates/find-repeated-customer-keys https://www.sql-practice.online/scenario/finding-duplicates/measure-completeness-within-duplicate-groups https://www.sql-practice.online/scenario/finding-duplicates/profile-null-aware-duplicate-conflicts https://www.sql-practice.online/scenario/finding-duplicates/quarantine-missing-business-keys https://www.sql-practice.online/scenario/finding-duplicates/return-every-row-in-a-normalized-duplicate-group https://www.sql-practice.online/scenario/finding-duplicates/select-a-deterministic-survivor https://www.sql-practice.online/scenario/joins https://www.sql-practice.online/scenario/joins/all-departments-with-employee-count-left-join https://www.sql-practice.online/scenario/joins/anti-join-via-not-exists-employees-without-direct-reports https://www.sql-practice.online/scenario/joins/cross-join-every-department-every-job-cartesian-product https://www.sql-practice.online/scenario/joins/departments-with-their-employees-left-join-empty-groups-visible https://www.sql-practice.online/scenario/joins/employee-details-department-job-multi-inner-join https://www.sql-practice.online/scenario/joins/employees-with-department-names-inner-join https://www.sql-practice.online/scenario/joins/employees-with-manager-name-self-join-left-join https://www.sql-practice.online/scenario/joins/inequality-join-map-salaries-to-pay-bands-on-between https://www.sql-practice.online/scenario/joins/keep-unassigned-employees-in-an-as-of-project-roster https://www.sql-practice.online/scenario/joins/many-to-many-employees-projects-via-junction-table https://www.sql-practice.online/scenario/joins/pairs-of-employees-with-the-same-job-title https://www.sql-practice.online/scenario/joins/prevent-fan-out-in-an-order-reconciliation https://www.sql-practice.online/scenario/joins/reconcile-crm-and-billing-accounts-with-full-outer-join https://www.sql-practice.online/scenario/joins/semi-join-via-exists-departments-that-have-a-manager https://www.sql-practice.online/scenario/joins/temporal-as-of-join-salary-on-a-specific-date https://www.sql-practice.online/scenario/joins/using-compact-equality-join-on-same-named-columns https://www.sql-practice.online/scenario/limit-offset https://www.sql-practice.online/scenario/limit-offset/build-a-filtered-pagination-contract https://www.sql-practice.online/scenario/limit-offset/calculate-and-return-page-two https://www.sql-practice.online/scenario/limit-offset/continue-with-a-composite-keyset-cursor https://www.sql-practice.online/scenario/limit-offset/include-every-row-tied-at-the-cutoff https://www.sql-practice.online/scenario/limit-offset/resume-a-bounded-backfill-batch https://www.sql-practice.online/scenario/limit-offset/return-a-deterministic-first-batch https://www.sql-practice.online/scenario/limit-offset/return-a-stable-top-three https://www.sql-practice.online/scenario/order-by-sorting https://www.sql-practice.online/scenario/order-by-sorting/apply-a-custom-department-priority https://www.sql-practice.online/scenario/order-by-sorting/build-a-multi-rule-employee-directory https://www.sql-practice.online/scenario/order-by-sorting/make-a-sort-deterministic https://www.sql-practice.online/scenario/order-by-sorting/normalize-case-before-sorting https://www.sql-practice.online/scenario/order-by-sorting/put-missing-deadlines-last https://www.sql-practice.online/scenario/order-by-sorting/rank-aggregated-department-headcount https://www.sql-practice.online/scenario/order-by-sorting/rank-by-calculated-compensation https://www.sql-practice.online/scenario/order-by-sorting/rank-salaries-from-highest-to-lowest https://www.sql-practice.online/scenario/order-by-sorting/return-a-stable-top-three https://www.sql-practice.online/scenario/order-by-sorting/show-most-recent-hires-first https://www.sql-practice.online/scenario/order-by-sorting/sort-a-combined-operations-queue https://www.sql-practice.online/scenario/order-by-sorting/sort-by-a-select-alias https://www.sql-practice.online/scenario/order-by-sorting/sort-employees-by-joined-department-name https://www.sql-practice.online/scenario/order-by-sorting/sort-salaries-from-lowest-to-highest https://www.sql-practice.online/scenario/order-by-sorting/sort-within-department-groups https://www.sql-practice.online/scenario/ranking-nth-value https://www.sql-practice.online/scenario/ranking-nth-value/allocate-runs-into-deterministic-quartiles-with-ntile https://www.sql-practice.online/scenario/ranking-nth-value/assign-a-deterministic-global-run-sequence https://www.sql-practice.online/scenario/ranking-nth-value/broadcast-the-deterministic-top-run-per-pipeline https://www.sql-practice.online/scenario/ranking-nth-value/broadcast-the-second-ordered-run-with-nth-value https://www.sql-practice.online/scenario/ranking-nth-value/calculate-a-deterministic-running-load-total https://www.sql-practice.online/scenario/ranking-nth-value/compare-each-run-with-its-predecessor https://www.sql-practice.online/scenario/ranking-nth-value/compare-percent-rank-with-cume-dist-at-ties https://www.sql-practice.online/scenario/ranking-nth-value/compute-a-three-run-moving-runtime-average https://www.sql-practice.online/scenario/ranking-nth-value/expose-the-next-scheduled-run https://www.sql-practice.online/scenario/ranking-nth-value/flag-runtime-regressions-against-the-previous-run https://www.sql-practice.online/scenario/ranking-nth-value/keep-every-top-throughput-tie-per-pipeline https://www.sql-practice.online/scenario/ranking-nth-value/measure-relative-runtime-rank-per-pipeline https://www.sql-practice.online/scenario/ranking-nth-value/rank-pipeline-runs-while-preserving-ties https://www.sql-practice.online/scenario/ranking-nth-value/rank-throughput-within-each-pipeline https://www.sql-practice.online/scenario/ranking-nth-value/read-the-partition-tail-with-last-value https://www.sql-practice.online/scenario/ranking-nth-value/return-the-third-distinct-throughput-level https://www.sql-practice.online/scenario/ranking-nth-value/select-exactly-two-runs-per-pipeline https://www.sql-practice.online/scenario/select-statements https://www.sql-practice.online/scenario/select-statements/add-a-constant-literal-column https://www.sql-practice.online/scenario/select-statements/basic-select-all-columns https://www.sql-practice.online/scenario/select-statements/boolean-expression-in-select https://www.sql-practice.online/scenario/select-statements/capstone-compose-a-projection https://www.sql-practice.online/scenario/select-statements/distinct-on-multiple-columns https://www.sql-practice.online/scenario/select-statements/null-aware-arithmetic https://www.sql-practice.online/scenario/select-statements/reorder-the-projected-columns https://www.sql-practice.online/scenario/select-statements/select-distinct https://www.sql-practice.online/scenario/select-statements/select-specific-columns https://www.sql-practice.online/scenario/select-statements/select-with-case-statement https://www.sql-practice.online/scenario/select-statements/select-with-column-aliases https://www.sql-practice.online/scenario/select-statements/select-with-expressions https://www.sql-practice.online/scenario/select-statements/select-with-in-operator https://www.sql-practice.online/scenario/select-statements/select-with-like-pattern https://www.sql-practice.online/scenario/select-statements/select-with-limit https://www.sql-practice.online/scenario/select-statements/select-with-multiple-conditions https://www.sql-practice.online/scenario/select-statements/select-with-null-handling https://www.sql-practice.online/scenario/select-statements/select-with-order-by https://www.sql-practice.online/scenario/select-statements/select-with-string-concatenation https://www.sql-practice.online/scenario/select-statements/select-with-string-functions https://www.sql-practice.online/scenario/select-statements/select-with-where-clause https://www.sql-practice.online/scenario/select-statements/select-without-from https://www.sql-practice.online/scenario/select-statements/use-a-table-alias https://www.sql-practice.online/scenario/self-joins-hierarchical https://www.sql-practice.online/scenario/self-joins-hierarchical/bill-of-materials-hierarchy-recursive-walk https://www.sql-practice.online/scenario/self-joins-hierarchical/department-hierarchy-with-true-cumulative-budget-rollup https://www.sql-practice.online/scenario/self-joins-hierarchical/detect-cycles-in-a-parent-hierarchy-safely https://www.sql-practice.online/scenario/self-joins-hierarchical/dfs-pre-order-org-chart-with-indentation https://www.sql-practice.online/scenario/self-joins-hierarchical/direct-manager-and-skip-level-manager https://www.sql-practice.online/scenario/self-joins-hierarchical/each-employee-s-direct-report-count https://www.sql-practice.online/scenario/self-joins-hierarchical/employees-earning-more-than-their-manager https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-managers-in-reporting-chain-path-to-ceo https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-subordinates-under-a-manager-including-herself https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employee-manager-details-using-self-join https://www.sql-practice.online/scenario/self-joins-hierarchical/find-pairs-of-employees-in-the-same-department https://www.sql-practice.online/scenario/self-joins-hierarchical/lowest-common-ancestor-of-two-employees https://www.sql-practice.online/scenario/self-joins-hierarchical/organizational-hierarchy-with-path-recursive-cte https://www.sql-practice.online/scenario/self-joins-hierarchical/reverse-bill-of-materials-where-used-spoke https://www.sql-practice.online/scenario/self-joins-hierarchical/total-cost-of-product-including-all-sub-components https://www.sql-practice.online/scenario/self-joins-hierarchical/total-payroll-under-each-manager-subtree-salary-sum https://www.sql-practice.online/scenario/subqueries https://www.sql-practice.online/scenario/subqueries/find-accounts-without-flags-using-null-safe-not-exists https://www.sql-practice.online/scenario/subqueries/find-departments-larger-than-the-average-department https://www.sql-practice.online/scenario/subqueries/find-departments-where-every-employee-clears-the-pay-floor https://www.sql-practice.online/scenario/subqueries/find-departments-with-an-above-average-earner https://www.sql-practice.online/scenario/subqueries/find-employees-above-the-company-average https://www.sql-practice.online/scenario/subqueries/find-employees-above-their-department-average https://www.sql-practice.online/scenario/subqueries/find-employees-in-west-coast-departments-with-in https://www.sql-practice.online/scenario/subqueries/find-every-top-paid-employee-per-department https://www.sql-practice.online/scenario/subqueries/find-every-top-paid-employee-per-job-with-a-row-subquery https://www.sql-practice.online/scenario/subqueries/find-salaries-higher-than-all-hr-salaries https://www.sql-practice.online/scenario/subqueries/find-salaries-higher-than-any-hr-salary https://www.sql-practice.online/scenario/subqueries/show-each-salary-against-the-company-average https://www.sql-practice.online/scenario/where-clause https://www.sql-practice.online/scenario/where-clause/apply-one-salary-rule-to-two-teams https://www.sql-practice.online/scenario/where-clause/audit-candidates-across-numeric-boundaries https://www.sql-practice.online/scenario/where-clause/audit-unusable-active-contact-numbers https://www.sql-practice.online/scenario/where-clause/build-a-production-review-cohort https://www.sql-practice.online/scenario/where-clause/exclude-jobs-safely-when-rules-contain-null https://www.sql-practice.online/scenario/where-clause/extract-february-payment-events https://www.sql-practice.online/scenario/where-clause/find-employees-by-name-prefix https://www.sql-practice.online/scenario/where-clause/locate-an-employee-by-first-name https://www.sql-practice.online/scenario/where-clause/match-imported-names-across-letter-case https://www.sql-practice.online/scenario/where-clause/review-candidates-at-inclusive-salary-boundaries https://www.sql-practice.online/scenario/where-clause/rewrite-a-date-filter-for-index-use https://www.sql-practice.online/scenario/where-clause/select-employees-for-role-mapping