https://www.sql-practice.online/scenario/aggregations 2025-03-02T09:51:37.618Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary 2024-02-28T05:59:23.421Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary-by-department 2025-10-21T01:55:29.658Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/conditional-salary-aggregation 2024-09-28T08:25:40.055Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-departments-with-employees 2024-05-05T13:28:41.849Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-job-titles 2025-01-08T15:45:56.866Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-total-employees 2024-02-26T09:41:56.012Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-efficiency-metrics 2025-07-06T03:30:34.657Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-salary-summary 2026-01-30T17:46:35.135Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-high-average-salary 2024-01-14T16:07:03.677Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-multiple-conditions 2024-06-20T05:07:50.629Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department 2025-07-04T19:52:49.540Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department-and-job 2025-08-13T18:19:34.991Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/hire-year-analysis 2024-07-10T01:51:04.492Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/job-title-statistics 2024-06-11T11:10:46.552Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/manager-vs-non-manager-analysis 2025-12-13T16:06:49.012Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/minimum-and-maximum-salaries 2026-04-07T16:47:13.311Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-distribution-by-range 2025-07-14T06:39:28.722Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-percentiles-by-department 2024-04-14T07:28:11.191Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/tenure-based-salary-analysis 2025-07-16T02:15:54.915Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/total-salary-expenditure 2024-10-03T06:05:34.128Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements 2024-04-22T14:38:24.713Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/assign-customer-loyalty-tiers 2025-12-10T20:42:33.286Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-commission-based-on-sales-tier 2025-04-23T16:34:16.854Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-discount-based-on-order-quantity 2025-02-05T22:41:10.605Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/categorize-employees-by-salary-band 2024-04-21T18:43:12.200Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-inventory-levels 2026-05-01T08:26:35.059Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-products-by-price-range 2024-03-21T15:24:39.534Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/compare-department-salary-with-company-average 2025-03-29T08:04:29.065Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/complex-multi-table-conditional-logic 2024-08-13T19:09:11.474Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---count-by-performance-level 2025-07-05T22:16:41.432Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---sum-by-category 2025-11-15T06:25:49.983Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/employee-tax-bracket-assignment 2024-05-04T15:51:18.420Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/identify-highest-and-lowest-salary-in-each-department 2025-10-03T18:11:04.010Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/multi-condition-promotion-eligibility 2025-04-16T17:42:45.165Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/nested-case---classify-sales-with-discount-by-customer-type 2025-10-23T06:16:24.552Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/product-performance-classification 2024-01-12T20:57:49.699Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window 2024-06-18T18:33:44.527Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/advanced-window-functions---moving-averages-and-percentiles 2025-06-21T05:54:40.209Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/basic-cte-for-department-summary 2026-04-11T19:46:15.031Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/complex-cte-chain---salary-growth-analysis 2026-02-03T13:41:53.463Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/lag-and-lead-for-salary-comparison 2025-04-27T12:25:46.394Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/multiple-ctes-for-comprehensive-analysis 2025-09-07T07:28:57.830Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/ntile-for-quartile-distribution 2024-12-06T14:57:41.411Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/rank-and-dense-rank-for-salary-positioning 2024-03-22T18:01:02.798Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/recursive-cte-for-organization-hierarchy 2025-01-19T17:46:27.125Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/row-number-for-employee-ranking 2024-07-28T08:45:14.627Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/running-total-of-salaries-by-department 2025-02-13T13:40:58.010Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations 2024-01-25T13:51:58.582Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-7-day-rolling-average-revenue 2024-10-10T21:06:21.460Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-days-between-order-and-shipping 2026-04-20T19:02:17.575Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-month-to-date-mtd-revenue 2024-11-18T16:34:24.937Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-year-to-date-ytd-sales-by-month 2024-06-19T16:44:01.781Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cohort-analysis---customer-retention-by-signup-month 2025-03-13T01:08:44.926Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cumulative-sum-with-monthly-reset 2025-07-02T19:33:15.126Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/customer-lifetime-value-clv-by-cohort 2024-12-30T00:25:54.933Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/employee-tenure-calculation 2025-07-25T10:27:30.761Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/extract-month-and-year-from-order-date 2025-01-10T20:13:05.469Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-active-customers-in-last-30-days 2025-08-22T08:15:20.138Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-customers-inactive-for-90-days 2025-01-24T07:10:25.137Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/fiscal-quarter-segmentation 2025-09-17T22:49:19.908Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-peak-transaction-hours 2026-01-23T22:17:04.342Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-week-on-week-wow-sales-growth 2025-07-08T20:54:17.635Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/year-over-year-yoy-sales-comparison 2025-05-10T09:15:41.731Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates 2025-11-19T05:53:42.776Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/analyze-duplicate-patterns-and-data-inconsistencies 2025-09-26T18:37:20.876Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/comprehensive-data-quality-scorecard 2025-11-25T09:04:09.805Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/count-total-duplicate-email-addresses 2025-11-02T16:48:26.614Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-all-records-with-duplicate-first-names 2024-03-28T17:42:40.415Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-completeness-score-by-email-group 2026-03-12T13:07:39.933Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-quality-issues-across-multiple-columns 2025-02-04T19:48:10.480Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-email-addresses 2025-02-01T04:49:51.772Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-and-assign-row-numbers 2025-03-29T11:27:28.860Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-using-self-join 2024-08-12T02:27:06.824Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-rows-using-cte-common-table-expression 2024-02-18T18:01:57.015Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-latest-record-for-each-duplicate-group 2026-03-25T18:52:09.412Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-missing-critical-data-multiple-null-checks 2025-01-22T15:23:37.154Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-with-null-values-in-salary 2024-09-12T23:40:17.360Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-complete-duplicate-records 2026-02-09T15:11:09.595Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-records-for-deletion-keep-oldest-delete-newest 2025-02-07T01:46:09.984Z weekly 0.8 https://www.sql-practice.online/scenario/joins 2025-11-20T08:39:55.368Z weekly 0.8 https://www.sql-practice.online/scenario/joins/advanced-join-performance-analysis 2024-12-13T13:13:17.996Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-departments-with-employee-count 2025-01-13T19:41:14.470Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-jobs-with-employee-assignment-status-right-join 2024-10-30T16:53:44.472Z weekly 0.8 https://www.sql-practice.online/scenario/joins/complete-employee-profile 2025-11-09T17:45:20.462Z weekly 0.8 https://www.sql-practice.online/scenario/joins/comprehensive-employee-department-job-report 2024-07-14T21:28:30.203Z weekly 0.8 https://www.sql-practice.online/scenario/joins/cross-join---all-department-job-combinations 2026-02-18T09:58:07.287Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-hierarchy-with-managers 2025-11-24T13:03:17.562Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-job-matrix-with-employee-counts 2024-04-30T06:34:23.248Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-salary-statistics 2024-02-28T02:23:38.766Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-location-and-employee-info 2025-08-21T05:19:40.841Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-managers-semi-join 2024-05-07T08:33:33.504Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-department-names 2025-01-31T11:48:33.134Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-details-with-department-and-job 2024-04-11T03:53:36.567Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-hire-date-analysis-with-joins 2026-02-27T19:08:50.864Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-job-titles 2024-02-01T16:31:42.674Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-manager-relationships 2026-04-27T19:54:15.246Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-above-job-minimum-salary 2025-02-27T22:40:49.452Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-higher-salaries-than-department-average 2026-02-04T09:47:59.093Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-same-job-title 2024-07-10T02:06:46.908Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-without-direct-reports-anti-join 2024-09-09T01:26:22.847Z weekly 0.8 https://www.sql-practice.online/scenario/joins/job-salary-range-analysis 2024-04-26T23:35:42.164Z weekly 0.8 https://www.sql-practice.online/scenario/joins/manager-team-summary 2024-11-15T13:08:42.067Z weekly 0.8 https://www.sql-practice.online/scenario/joins/multi-level-management-hierarchy 2024-10-26T05:31:38.544Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-comparison-within-departments 2026-04-06T00:46:35.853Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-range-matching-inequality-join 2026-02-05T18:50:28.747Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value 2025-03-04T02:43:55.930Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/assign-row-numbers-to-employees-by-salary 2024-12-23T15:45:26.591Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/compare-employee-salary-with-previous-employee-by-hire-date 2026-05-08T16:29:05.383Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-consecutive-employees-with-increasing-salaries 2024-03-04T13:44:36.546Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-distinct-nth-highest-salary-using-dense-rank 2025-03-22T13:21:21.670Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-employees-who-earn-more-than-their-manager 2026-04-26T23:32:13.657Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-highest-salary-in-each-department 2024-11-27T00:24:14.055Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-salary-percentile-rank-for-each-employee 2024-05-29T00:49:09.778Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-nth-highest-salary-across-all-departments 2025-04-18T10:30:42.508Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-second-highest-salary 2025-10-26T17:33:15.588Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-2-employees-by-salary-in-each-department 2025-04-15T23:59:12.406Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-3-highest-paid-employees 2024-11-07T13:38:20.812Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-all-employees-by-salary 2024-09-17T03:19:04.209Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-and-find-those-in-top-25-by-salary 2025-04-08T21:35:58.861Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-within-each-department 2025-08-14T13:52:58.536Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/show-salary-difference-between-current-and-next-higher-salary 2025-01-12T22:40:46.042Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical 2025-10-14T10:59:48.693Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/calculate-total-cost-of-product-with-sub-components 2024-07-24T02:16:46.445Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/compare-employee-to-their-manager-on-multiple-attributes 2024-04-24T11:36:32.487Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/department-hierarchy-with-budget-rollup 2025-12-16T13:37:38.992Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/direct-manager-and-skip-level-manager 2024-02-29T14:47:32.611Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/employees-earning-more-than-their-manager 2025-07-02T22:52:03.796Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-managers-in-reporting-chain-path-to-ceo 2026-02-03T04:07:37.914Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-subordinates-under-a-manager 2024-07-03T19:14:44.856Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employee-manager-details-using-self-join 2026-01-10T18:58:48.916Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-and-their-direct-reports-count 2024-07-08T22:18:24.869Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-at-specific-hierarchy-level 2025-08-16T21:35:33.587Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-managers-with-most-direct-reports 2025-07-16T03:57:27.284Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-pairs-of-employees-in-same-department 2025-06-09T00:19:46.273Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-product-component-hierarchy-bill-of-materials 2024-07-13T04:54:36.708Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/hierarchy-level-and-team-size-for-each-employee 2026-05-04T03:00:40.299Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/organizational-hierarchy---all-levels-using-recursive-cte 2024-04-21T14:10:15.736Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries 2026-02-27T06:14:16.241Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/complex-nested-subquery-analysis 2024-06-09T03:27:09.621Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-above-average-employee-count 2025-05-13T17:14:40.856Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-all-high-earners 2025-01-13T07:31:33.511Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-salary-diversity 2025-02-07T02:25:03.956Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-above-average 2025-10-30T22:07:37.499Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-more-than-their-department-average 2026-02-05T22:35:20.097Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-departments-with-managers 2025-05-06T12:32:38.902Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-the-highest-paying-department 2025-12-08T08:26:20.256Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-with-same-job-as-john-smith 2025-08-18T14:24:41.337Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/jobs-with-no-employees 2024-10-08T19:18:39.759Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/salary-ranking-with-subqueries 2025-05-18T16:35:12.804Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/second-highest-salary 2024-01-27T12:42:39.256Z weekly 0.8