https://www.sql-practice.online/scenario/aggregations 2024-03-05T13:42:04.763Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary 2024-12-13T15:27:39.621Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/average-salary-by-department 2024-10-29T20:13:56.420Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/conditional-salary-aggregation 2025-12-28T19:19:00.212Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-departments-with-employees 2024-02-13T11:16:28.202Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-distinct-job-titles 2024-08-02T01:14:31.528Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/count-total-employees 2025-01-10T08:55:16.155Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-efficiency-metrics 2024-05-25T04:36:25.846Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/department-salary-summary 2025-04-10T19:01:23.285Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-high-average-salary 2024-09-11T11:48:57.806Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/departments-with-multiple-conditions 2025-03-28T12:30:13.887Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department 2025-01-23T18:54:35.748Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/employee-count-by-department-and-job 2025-08-10T23:41:07.166Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/hire-year-analysis 2026-02-16T06:30:11.092Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/job-title-statistics 2025-02-06T01:39:16.454Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/manager-vs-non-manager-analysis 2025-07-08T07:59:52.320Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/minimum-and-maximum-salaries 2026-05-05T17:07:13.656Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-distribution-by-range 2024-11-08T15:16:10.297Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/salary-percentiles-by-department 2026-05-15T08:37:39.738Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/tenure-based-salary-analysis 2025-01-31T22:27:33.927Z weekly 0.8 https://www.sql-practice.online/scenario/aggregations/total-salary-expenditure 2024-05-28T02:55:55.702Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements 2025-02-21T13:06:13.915Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/assign-customer-loyalty-tiers 2024-06-26T05:05:35.063Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-commission-based-on-sales-tier 2024-09-19T19:33:23.323Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/calculate-discount-based-on-order-quantity 2026-04-03T20:33:41.957Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/categorize-employees-by-salary-band 2024-06-17T02:23:48.125Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-inventory-levels 2024-01-24T04:03:17.728Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/classify-products-by-price-range 2024-10-12T01:40:06.191Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/compare-department-salary-with-company-average 2024-11-09T08:46:38.516Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/complex-multi-table-conditional-logic 2026-04-26T05:48:35.457Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---count-by-performance-level 2026-03-03T19:09:43.142Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/conditional-aggregation---sum-by-category 2024-03-24T03:59:26.605Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/employee-tax-bracket-assignment 2026-05-15T19:57:47.073Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/identify-highest-and-lowest-salary-in-each-department 2025-04-06T07:12:41.998Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/multi-condition-promotion-eligibility 2024-07-02T15:50:03.884Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/nested-case---classify-sales-with-discount-by-customer-type 2026-02-21T07:55:10.400Z weekly 0.8 https://www.sql-practice.online/scenario/case-statements/product-performance-classification 2026-05-26T04:58:08.268Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window 2025-05-09T22:16:15.794Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/3-row-moving-average-of-salaries-explicit-rows-frame 2025-10-27T04:40:00.077Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/advanced-window-functions---moving-averages-and-percentiles 2024-07-25T11:35:47.753Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/basic-cte-for-department-summary 2024-10-17T09:53:27.272Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/complex-cte-chain---salary-growth-analysis 2024-12-26T23:36:03.535Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/consecutive-year-salary-record-streaks-gaps-islands 2024-08-22T15:55:50.062Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/cumulative-of-department-salary-budget 2025-12-02T20:14:43.593Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/delta-from-starting-salary-first-value 2026-04-05T04:29:12.942Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/first-and-latest-salary-per-employee-first-value-last-value 2026-07-03T05:50:18.896Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/keep-only-the-latest-salary-per-employee-deduplication 2026-06-04T23:00:46.389Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/lag-and-lead-for-salary-comparison 2025-08-11T09:53:50.531Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/multiple-ctes-for-comprehensive-analysis 2025-09-26T16:29:38.284Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/ntile-for-quartile-distribution 2025-03-18T14:10:31.660Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/rank-and-dense-rank-for-salary-positioning 2024-04-06T01:25:43.986Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/recursive-cte-for-organization-hierarchy 2025-01-20T15:06:45.232Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/row-number-for-employee-ranking 2025-01-12T05:46:08.483Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/running-total-of-salaries-by-department 2025-10-29T05:30:31.415Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/running-total-rows-vs-range-frame 2025-01-11T05:06:49.958Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/salary-distribution-per-department-percent-rank-cume-dist 2024-04-14T18:44:46.836Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/second-highest-salary-per-department-nth-value 2024-12-03T06:22:11.382Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/top-3-earners-per-department-row-number-3 2026-03-24T05:16:39.769Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/top-earner-per-department-row-number-1 2024-03-28T12:02:15.438Z weekly 0.8 https://www.sql-practice.online/scenario/ctes-window/year-over-year-salary-growth-lag-on-history 2026-05-20T20:34:43.499Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations 2024-01-16T21:44:58.014Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/busiest-day-of-the-week 2026-07-03T14:21:33.578Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-7-day-rolling-average-revenue 2024-06-05T16:09:35.134Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-days-between-order-and-shipping 2024-03-27T14:45:18.247Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-month-to-date-mtd-revenue 2026-05-30T06:52:23.976Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/calculate-year-to-date-ytd-sales-by-month 2024-12-04T03:31:53.118Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cohort-analysis---customer-retention-by-signup-month 2025-04-30T06:43:28.031Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/cumulative-sum-with-monthly-reset 2025-10-10T17:44:30.116Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/customer-first-order-last-order-and-lifespan 2025-10-05T18:38:20.358Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/customer-lifetime-value-clv-by-cohort 2025-09-15T20:09:08.707Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/days-between-consecutive-orders-per-customer 2025-11-23T16:08:42.012Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/employee-tenure-calculation 2024-05-23T08:05:51.568Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/employee-tenure-in-years-and-months 2026-02-06T18:48:11.420Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/extract-month-and-year-from-order-date 2024-08-27T21:58:11.330Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-active-customers-in-last-30-days 2024-05-12T15:49:54.461Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/find-customers-inactive-for-90-days 2025-05-22T14:10:44.561Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/fiscal-quarter-segmentation 2025-11-24T19:37:37.433Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-peak-transaction-hours 2025-01-18T01:48:49.882Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/identify-week-on-week-wow-sales-growth 2024-12-16T11:49:58.341Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/monthly-revenue-summary-portable-month-bucketing 2025-04-12T10:35:57.287Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/quarter-over-quarter-qoq-sales-growth 2024-01-27T02:50:23.546Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/shipping-sla-breach-slower-than-3-days 2025-09-16T06:08:14.632Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/time-to-first-repeat-purchase 2025-08-31T10:45:04.717Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/weekend-vs-weekday-revenue-split 2026-04-19T23:08:30.514Z weekly 0.8 https://www.sql-practice.online/scenario/date-operations/year-over-year-yoy-sales-comparison 2025-04-02T03:23:36.425Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates 2024-09-14T22:54:44.771Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/analyze-duplicate-patterns-and-data-inconsistencies 2025-01-15T22:44:55.854Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/comprehensive-data-quality-scorecard 2026-05-05T06:00:04.760Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/count-total-duplicate-email-addresses 2026-06-30T22:29:13.331Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-all-records-with-duplicate-first-names 2024-02-12T23:09:46.090Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-completeness-score-by-email-group 2025-05-22T05:34:43.448Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-data-quality-issues-across-multiple-columns 2025-09-06T21:34:33.758Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-email-addresses 2025-09-07T15:50:52.638Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-and-assign-row-numbers 2024-08-11T21:52:42.298Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-records-using-self-join 2026-03-05T18:06:43.901Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-duplicate-rows-using-cte-common-table-expression 2025-06-01T23:16:22.664Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-latest-record-for-each-duplicate-group 2024-09-02T02:36:28.506Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-missing-critical-data-multiple-null-checks 2026-04-14T10:46:01.959Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/find-records-with-null-values-in-salary 2026-01-22T14:02:29.071Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-complete-duplicate-records 2026-03-06T12:41:03.048Z weekly 0.8 https://www.sql-practice.online/scenario/finding-duplicates/identify-records-for-deletion-keep-oldest-delete-newest 2026-05-01T18:45:19.768Z weekly 0.8 https://www.sql-practice.online/scenario/joins 2024-12-30T06:08:31.319Z weekly 0.8 https://www.sql-practice.online/scenario/joins/advanced-join-performance-analysis 2026-06-24T10:31:50.773Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-departments-with-employee-count 2025-10-09T01:42:02.084Z weekly 0.8 https://www.sql-practice.online/scenario/joins/all-jobs-with-employee-assignment-status-right-join 2025-06-03T23:17:26.459Z weekly 0.8 https://www.sql-practice.online/scenario/joins/complete-employee-profile 2025-06-13T18:08:48.141Z weekly 0.8 https://www.sql-practice.online/scenario/joins/comprehensive-employee-department-job-report 2025-08-18T17:40:41.784Z weekly 0.8 https://www.sql-practice.online/scenario/joins/cross-join---all-department-job-combinations 2026-03-01T07:53:33.824Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-hierarchy-with-managers 2025-10-24T04:03:42.307Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-job-matrix-with-employee-counts 2026-04-08T18:05:39.355Z weekly 0.8 https://www.sql-practice.online/scenario/joins/department-salary-statistics 2024-09-08T00:42:31.106Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-location-and-employee-info 2024-06-01T16:21:46.015Z weekly 0.8 https://www.sql-practice.online/scenario/joins/departments-with-managers-semi-join 2025-01-02T21:14:53.969Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-department-names 2025-09-15T00:55:26.698Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-details-with-department-and-job 2026-03-15T16:09:07.430Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-hire-date-analysis-with-joins 2025-12-05T19:19:55.022Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-job-titles 2024-02-11T01:02:05.420Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employee-manager-relationships 2025-11-25T11:03:05.423Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-above-job-minimum-salary 2026-01-02T15:11:01.196Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-higher-salaries-than-department-average 2024-10-20T02:54:33.167Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-with-same-job-title 2026-03-14T02:28:36.845Z weekly 0.8 https://www.sql-practice.online/scenario/joins/employees-without-direct-reports-anti-join 2025-06-25T17:55:15.228Z weekly 0.8 https://www.sql-practice.online/scenario/joins/job-salary-range-analysis 2025-12-31T06:22:02.021Z weekly 0.8 https://www.sql-practice.online/scenario/joins/manager-team-summary 2024-01-31T20:03:45.735Z weekly 0.8 https://www.sql-practice.online/scenario/joins/multi-level-management-hierarchy 2026-05-05T06:24:33.659Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-comparison-within-departments 2024-09-26T11:03:40.214Z weekly 0.8 https://www.sql-practice.online/scenario/joins/salary-range-matching-inequality-join 2024-01-20T18:26:33.390Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value 2026-04-03T14:52:37.227Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/assign-row-numbers-to-employees-by-salary 2024-03-14T21:56:14.879Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/compare-employee-salary-with-previous-employee-by-hire-date 2026-04-07T21:30:37.213Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-consecutive-employees-with-increasing-salaries 2025-08-29T12:04:46.383Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-distinct-nth-highest-salary-using-dense-rank 2024-03-01T03:53:34.585Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-employees-who-earn-more-than-their-manager 2026-05-07T06:15:25.271Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-highest-salary-in-each-department 2025-12-21T22:04:55.305Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-salary-percentile-rank-for-each-employee 2025-12-01T02:26:19.798Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-nth-highest-salary-across-all-departments 2026-03-30T17:40:44.693Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-the-second-highest-salary 2025-06-23T00:50:25.616Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-2-employees-by-salary-in-each-department 2024-05-16T14:08:32.999Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/find-top-3-highest-paid-employees 2024-11-03T05:34:49.389Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-all-employees-by-salary 2025-06-17T08:35:34.525Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-and-find-those-in-top-25-by-salary 2025-08-23T05:13:41.541Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/rank-employees-within-each-department 2024-01-08T06:50:34.905Z weekly 0.8 https://www.sql-practice.online/scenario/ranking-nth-value/show-salary-difference-between-current-and-next-higher-salary 2024-04-01T02:01:27.384Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical 2024-10-31T15:35:49.957Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/calculate-total-cost-of-product-with-sub-components 2025-08-14T05:55:05.100Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/compare-employee-to-their-manager-on-multiple-attributes 2024-10-18T13:55:20.445Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/department-hierarchy-with-budget-rollup 2025-03-29T07:27:39.972Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/direct-manager-and-skip-level-manager 2024-08-14T17:23:42.770Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/employees-earning-more-than-their-manager 2024-06-19T15:30:11.509Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-managers-in-reporting-chain-path-to-ceo 2024-03-08T20:56:18.312Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-all-subordinates-under-a-manager 2025-05-10T08:10:34.344Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employee-manager-details-using-self-join 2024-10-30T23:19:01.910Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-and-their-direct-reports-count 2025-12-06T04:30:14.829Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-employees-at-specific-hierarchy-level 2024-01-18T09:38:29.847Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-managers-with-most-direct-reports 2024-01-08T17:40:43.210Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-pairs-of-employees-in-same-department 2026-01-02T06:24:46.717Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/find-product-component-hierarchy-bill-of-materials 2024-07-12T21:54:02.893Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/hierarchy-level-and-team-size-for-each-employee 2024-06-30T12:05:51.527Z weekly 0.8 https://www.sql-practice.online/scenario/self-joins-hierarchical/organizational-hierarchy---all-levels-using-recursive-cte 2025-05-30T18:25:57.647Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries 2024-12-10T14:53:06.295Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/complex-nested-subquery-analysis 2025-10-03T18:50:57.879Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-above-average-employee-count 2026-07-04T01:50:19.178Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-all-high-earners 2024-02-20T02:10:00.618Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/departments-with-salary-diversity 2025-02-28T07:03:40.005Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-above-average 2026-02-14T08:59:41.375Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-earning-more-than-their-department-average 2024-05-02T06:49:24.985Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-departments-with-managers 2026-06-05T09:29:02.719Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-in-the-highest-paying-department 2025-01-08T20:48:29.510Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/employees-with-same-job-as-john-smith 2025-02-27T13:43:53.240Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/jobs-with-no-employees 2025-05-07T04:13:47.671Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/salary-ranking-with-subqueries 2025-11-03T15:36:59.730Z weekly 0.8 https://www.sql-practice.online/scenario/subqueries/second-highest-salary 2026-05-12T14:33:26.621Z weekly 0.8