https://www.sql-practice.online/scenario/aggregations 2024-03-23T23:20:49.679Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary 2025-03-17T16:32:40.851Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary-by-department 2024-11-22T17:47:08.291Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/conditional-salary-aggregation 2026-02-15T21:41:25.010Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-departments-with-employees 2024-06-01T18:46:04.307Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-job-titles 2024-08-16T08:12:05.611Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-total-employees 2025-05-19T18:07:16.029Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-efficiency-metrics 2024-06-12T15:13:48.295Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-salary-summary 2025-04-25T04:54:49.967Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-high-average-salary 2024-09-19T22:04:27.137Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-multiple-conditions 2025-07-05T06:55:48.945Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department 2025-06-11T06:00:05.481Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department-and-job 2025-10-04T05:10:21.122Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/hire-year-analysis 2026-03-31T18:02:16.336Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/job-title-statistics 2025-04-17T13:58:43.610Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/manager-vs-non-manager-analysis 2025-09-12T11:46:23.445Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/minimum-and-maximum-salaries 2026-06-02T04:39:28.431Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-distribution-by-range 2024-12-26T19:10:11.836Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-percentiles-by-department 2026-06-22T04:20:47.895Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/tenure-based-salary-analysis 2025-06-03T16:23:35.922Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/total-salary-expenditure 2024-10-02T13:13:53.992Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements 2025-04-21T05:05:38.968Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/assign-customer-loyalty-tiers 2024-07-17T21:52:59.619Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-commission-based-on-sales-tier 2025-01-15T02:33:33.015Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-discount-based-on-order-quantity 2026-05-08T01:19:08.837Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/categorize-employees-by-salary-band 2024-06-28T01:14:04.233Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-inventory-levels 2024-05-27T07:12:32.796Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-products-by-price-range 2024-11-10T17:58:07.019Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/compare-department-salary-with-company-average 2025-02-07T20:51:12.152Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/complex-multi-table-conditional-logic 2024-02-02T16:44:42.878Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---count-by-performance-level 2026-07-04T04:18:04.334Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---sum-by-category 2024-04-10T23:57:25.621Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/employee-tax-bracket-assignment 2024-03-10T11:13:52.998Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/identify-highest-and-lowest-salary-in-each-department 2025-04-06T11:07:12.126Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/multi-condition-promotion-eligibility 2024-09-12T10:26:52.800Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/nested-case---classify-sales-with-discount-by-customer-type 2026-05-19T10:53:48.880Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/product-performance-classification 2026-06-07T18:53:25.656Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window 2025-06-25T18:54:16.277Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/3-row-moving-average-of-salaries-explicit-rows-frame 2026-03-15T11:18:00.470Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/advanced-window-functions---moving-averages-and-percentiles 2024-10-13T17:26:45.296Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/basic-cte-for-department-summary 2024-12-30T05:21:34.601Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/complex-cte-chain---salary-growth-analysis 2025-02-02T19:19:11.692Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/consecutive-year-salary-record-streaks-gaps-islands 2024-10-12T00:35:38.383Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/cumulative-of-department-salary-budget 2026-04-24T02:12:23.895Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/delta-from-starting-salary-first-value 2026-04-12T01:36:56.019Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/first-and-latest-salary-per-employee-first-value-last-value 2024-02-05T20:15:58.764Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/keep-only-the-latest-salary-per-employee-deduplication 2024-03-01T07:45:09.025Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/lag-and-lead-for-salary-comparison 2025-12-11T05:21:29.267Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/multiple-ctes-for-comprehensive-analysis 2025-10-04T20:53:22.417Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/ntile-for-quartile-distribution 2025-06-23T13:36:35.266Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/rank-and-dense-rank-for-salary-positioning 2024-08-19T12:12:56.277Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/recursive-cte-for-organization-hierarchy 2025-04-16T03:59:02.065Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/row-number-for-employee-ranking 2025-02-16T08:01:21.929Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/running-total-of-salaries-by-department 2026-02-18T12:19:47.429Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/running-total-rows-vs-range-frame 2025-02-28T12:55:21.629Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/salary-distribution-per-department-percent-rank-cume-dist 2024-08-30T06:23:15.777Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/second-highest-salary-per-department-nth-value 2025-01-01T10:56:42.543Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/top-3-earners-per-department-row-number-3 2026-04-24T09:43:50.047Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/top-earner-per-department-row-number-1 2024-08-15T22:01:46.755Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/year-over-year-salary-growth-lag-on-history 2026-06-29T01:31:07.778Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations 2024-04-18T15:33:58.188Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/busiest-day-of-the-week 2024-03-13T15:17:03.663Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-7-day-rolling-average-revenue 2024-09-23T00:37:46.086Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-days-between-order-and-shipping 2024-04-16T03:45:33.607Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-month-to-date-mtd-revenue 2024-03-09T08:53:32.677Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-year-to-date-ytd-sales-by-month 2025-04-22T02:20:49.834Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cohort-analysis---customer-retention-by-signup-month 2025-05-15T22:54:17.851Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cumulative-sum-with-monthly-reset 2026-02-04T17:54:17.084Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/customer-first-order-last-order-and-lifespan 2025-10-27T03:36:44.658Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/customer-lifetime-value-clv-by-cohort 2025-11-13T13:07:09.851Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/days-between-consecutive-orders-per-customer 2026-02-13T16:00:31.460Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/employee-tenure-calculation 2024-07-10T15:54:22.052Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/employee-tenure-in-years-and-months 2026-06-02T03:52:57.108Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/extract-month-and-year-from-order-date 2024-11-24T01:22:28.110Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-active-customers-in-last-30-days 2024-06-17T10:41:45.089Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-customers-inactive-for-90-days 2025-10-10T22:38:35.665Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/fiscal-quarter-segmentation 2026-02-24T16:55:27.157Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-peak-transaction-hours 2025-02-28T06:37:52.266Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-week-on-week-wow-sales-growth 2025-03-10T18:24:49.581Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/monthly-revenue-summary-portable-month-bucketing 2025-08-30T17:39:32.559Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/quarter-over-quarter-qoq-sales-growth 2024-03-19T11:22:49.698Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/shipping-sla-breach-slower-than-3-days 2025-12-21T18:49:23.004Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/time-to-first-repeat-purchase 2025-12-24T00:17:19.765Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/weekend-vs-weekday-revenue-split 2024-02-16T17:38:46.403Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/year-over-year-yoy-sales-comparison 2025-05-29T13:05:36.545Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates 2024-09-29T11:44:04.052Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/analyze-duplicate-patterns-and-data-inconsistencies 2025-05-26T15:12:53.574Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/comprehensive-data-quality-scorecard 2026-06-11T19:51:26.796Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/count-total-duplicate-email-addresses 2024-04-02T10:46:01.080Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-all-records-with-duplicate-first-names 2024-04-22T22:47:03.598Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-completeness-score-by-email-group 2025-07-01T13:52:37.660Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-quality-issues-across-multiple-columns 2025-10-09T17:06:44.550Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-email-addresses 2025-12-17T01:21:26.550Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-and-assign-row-numbers 2024-12-06T10:18:58.882Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-using-self-join 2026-05-23T14:44:23.385Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-rows-using-cte-common-table-expression 2025-08-08T22:02:23.572Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-latest-record-for-each-duplicate-group 2024-09-19T03:01:56.882Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-missing-critical-data-multiple-null-checks 2026-05-30T09:54:15.587Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-with-null-values-in-salary 2026-04-02T01:56:16.195Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-complete-duplicate-records 2026-03-18T07:03:49.796Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-records-for-deletion-keep-oldest-delete-newest 2024-02-29T14:39:51.489Z weekly 0.8 https://www.sql-practice.online/scenario/joins 2025-03-07T08:23:25.703Z weekly 0.8 https://www.sql-practice.online/scenario/joins/advanced-join-performance-analysis 2024-02-19T12:18:47.383Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-departments-with-employee-count 2026-02-09T23:58:09.492Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-jobs-with-employee-assignment-status-right-join 2025-08-09T13:48:48.811Z weekly 0.8 https://www.sql-practice.online/scenario/joins/complete-employee-profile 2025-10-05T01:23:39.697Z weekly 0.8 https://www.sql-practice.online/scenario/joins/comprehensive-employee-department-job-report 2025-11-08T21:27:01.360Z weekly 0.8 https://www.sql-practice.online/scenario/joins/cross-join---all-department-job-combinations 2026-04-25T07:56:39.556Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-hierarchy-with-managers 2026-02-15T22:29:05.015Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-job-matrix-with-employee-counts 2026-06-16T06:32:25.711Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-salary-statistics 2024-11-09T17:25:50.386Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-location-and-employee-info 2024-06-07T14:02:28.155Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-managers-semi-join 2025-02-24T07:44:35.185Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-department-names 2025-12-19T17:05:26.898Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-details-with-department-and-job 2026-06-12T15:05:54.850Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-hire-date-analysis-with-joins 2026-01-06T07:36:04.790Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-job-titles 2024-03-29T04:30:27.476Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-manager-relationships 2026-01-10T04:19:33.859Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-above-job-minimum-salary 2026-04-12T22:44:20.044Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-higher-salaries-than-department-average 2024-11-19T09:51:56.975Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-same-job-title 2026-04-20T06:33:43.561Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-without-direct-reports-anti-join 2025-08-14T18:46:02.056Z weekly 0.8 https://www.sql-practice.online/scenario/joins/job-salary-range-analysis 2026-03-30T07:16:04.505Z weekly 0.8 https://www.sql-practice.online/scenario/joins/manager-team-summary 2024-03-17T16:16:06.767Z weekly 0.8 https://www.sql-practice.online/scenario/joins/multi-level-management-hierarchy 2024-02-05T11:50:58.685Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-comparison-within-departments 2025-01-10T06:31:25.882Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-range-matching-inequality-join 2024-02-22T15:55:59.246Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value 2024-02-06T05:06:23.351Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/assign-row-numbers-to-employees-by-salary 2024-04-09T07:38:34.847Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/compare-employee-salary-with-previous-employee-by-hire-date 2026-05-04T15:27:35.737Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-consecutive-employees-with-increasing-salaries 2025-09-05T20:55:59.675Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-distinct-nth-highest-salary-using-dense-rank 2024-05-16T17:48:12.277Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-employees-who-earn-more-than-their-manager 2026-06-05T07:54:03.119Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-highest-salary-in-each-department 2026-04-23T22:51:17.009Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-salary-percentile-rank-for-each-employee 2026-03-27T16:49:51.446Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-nth-highest-salary-across-all-departments 2026-04-16T17:07:35.537Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-second-highest-salary 2025-06-26T07:00:28.176Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-2-employees-by-salary-in-each-department 2024-09-27T11:47:55.747Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-3-highest-paid-employees 2024-12-19T14:29:18.337Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-all-employees-by-salary 2025-09-28T20:21:43.411Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-and-find-those-in-top-25-by-salary 2025-11-26T23:20:56.805Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-within-each-department 2024-02-11T14:31:54.381Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/show-salary-difference-between-current-and-next-higher-salary 2024-04-10T18:34:20.000Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical 2025-01-28T18:27:09.694Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/calculate-total-cost-of-product-with-sub-components 2025-11-03T15:07:31.568Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/compare-employee-to-their-manager-on-multiple-attributes 2025-03-09T15:58:27.125Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/department-hierarchy-with-budget-rollup 2025-06-02T18:37:31.428Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/direct-manager-and-skip-level-manager 2024-10-22T17:33:59.510Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/employees-earning-more-than-their-manager 2024-08-30T12:04:15.489Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-managers-in-reporting-chain-path-to-ceo 2024-04-16T05:21:33.456Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-subordinates-under-a-manager 2025-07-13T12:04:24.776Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employee-manager-details-using-self-join 2024-11-27T02:03:38.222Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-and-their-direct-reports-count 2026-01-25T00:27:53.997Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-at-specific-hierarchy-level 2024-04-01T00:13:27.703Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-managers-with-most-direct-reports 2024-02-03T09:14:48.370Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-pairs-of-employees-in-same-department 2026-04-01T16:06:26.989Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-product-component-hierarchy-bill-of-materials 2024-08-25T22:08:14.985Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/hierarchy-level-and-team-size-for-each-employee 2024-10-20T16:57:49.719Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/organizational-hierarchy---all-levels-using-recursive-cte 2025-07-05T13:17:48.275Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries 2025-03-04T07:47:14.143Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/complex-nested-subquery-analysis 2025-10-20T15:21:56.541Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-above-average-employee-count 2024-05-21T19:07:05.748Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-all-high-earners 2024-04-11T11:15:27.264Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-salary-diversity 2025-05-23T08:45:25.650Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-above-average 2026-05-29T19:14:10.955Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-more-than-their-department-average 2024-05-28T00:20:45.209Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-departments-with-managers 2024-03-14T01:18:20.321Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-the-highest-paying-department 2025-05-04T16:38:08.050Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-with-same-job-as-john-smith 2025-05-03T22:56:29.632Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/jobs-with-no-employees 2025-08-20T07:04:55.295Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/salary-ranking-with-subqueries 2025-12-06T12:07:48.861Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/second-highest-salary 2024-03-30T17:36:32.025Z weekly 0.8