https://www.sql-practice.online/interview/level-1-beginner 2026-02-15T14:17:01.676Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/communication-prompt 2025-07-31T03:54:17.547Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/communication-prompt/q-10-communication-prompt-60-second-answer 2025-01-14T08:25:52.978Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/debugging 2025-07-27T01:40:21.694Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/debugging/q-5-query-review-employee-lookup 2025-09-09T23:17:21.255Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/descriptive 2024-10-26T18:37:46.111Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/descriptive/q-2-where-vs-having 2025-05-17T23:19:18.326Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/fill-in-blank 2025-07-15T17:45:17.405Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/fill-in-blank/q-9-fill-in-order-by-limit 2026-02-24T05:38:48.197Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/multiple-choice 2025-07-01T00:30:39.994Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/multiple-choice/q-3-recent-orders-query-mcq 2025-03-29T05:35:43.988Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/optimization 2025-02-15T08:37:24.437Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/optimization/q-8-optimization-lite-pick-better-query 2025-07-17T23:07:07.530Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/output-prediction 2025-05-01T04:26:06.631Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/output-prediction/q-6-output-prediction-order-by-limit 2024-05-04T18:57:21.070Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/query-based 2025-08-10T20:36:18.431Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/query-based/q-1-top-sales-employees 2024-08-08T06:14:56.009Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/scenario-based 2025-05-11T05:14:58.438Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/scenario-based/q-7-scenario-inventory-reorder-list 2025-10-30T17:57:47.540Z weekly 0.7 https://www.sql-practice.online/interview/level-1-beginner/true-false 2025-01-02T23:28:25.564Z weekly 0.8 https://www.sql-practice.online/interview/level-1-beginner/true-false/q-4-count-and-null-behavior 2024-07-05T02:57:15.747Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master 2024-09-25T02:37:17.579Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/communication-prompt 2026-02-06T16:15:37.948Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1005-architecture-communication-round-read-model-strategy 2025-01-23T12:37:26.469Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1013-communication-2-minute-incident-reliability-brief 2025-11-14T06:20:48.607Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/communication-prompt/q-1021-communication-compliance-design-defense 2025-09-27T09:55:51.698Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging 2024-01-05T10:51:49.264Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/debugging/q-1004-debug-non-sargable-architecture-audit-query 2025-12-31T02:40:00.623Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1012-debug-idempotency-lookup-query 2026-04-11T03:33:53.971Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1018-debug-row-level-security-filter 2025-05-30T12:56:46.833Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1020-debug-runaway-full-table-scan-in-compliance-job 2025-04-06T05:32:28.882Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/debugging/q-1028-debug-partition-pruning-miss 2025-06-05T03:01:28.458Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive 2024-01-25T04:42:16.279Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1002-domain-ownership-boundaries-in-data-systems 2026-03-06T04:48:49.204Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1007-descriptive-audit-ready-temporal-modeling 2024-03-23T20:42:49.015Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1010-rpo-rto-design-trade-off-explanation 2026-02-26T15:37:42.583Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1015-descriptive-split-brain-prevention-in-failover 2024-04-12T01:06:30.891Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1023-descriptive-governance-operating-model 2026-01-22T06:02:47.174Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1026-descriptive-slo-driven-capacity-planning 2024-02-13T17:59:06.399Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1030-descriptive-workload-classes-and-admission-control 2026-02-13T00:56:34.384Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1034-descriptive-architecture-decision-memo-structure 2025-10-12T16:40:22.409Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1037-descriptive-decision-acceptance-criteria 2025-02-08T12:56:18.396Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/descriptive/q-1039-descriptive-cross-functional-trade-off-negotiation 2024-12-22T09:14:46.752Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/module/m1-end-to-end-data-architecture 2024-02-12T03:32:46.722Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m2-reliability-ha-dr-multi-region 2024-05-13T03:53:01.231Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m3-governance-security-cost-control 2024-01-01T21:03:13.161Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m4-platform-performance-capacity-strategy 2024-10-28T15:12:09.211Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/module/m5-architecture-leadership-decision-rounds 2025-12-21T00:00:21.341Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/optimization 2024-12-17T10:58:31.477Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/optimization/q-1003-optimization-event-time-filter-strategy-for-serving-api 2025-07-12T21:56:35.473Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1011-optimization-better-replication-lag-monitor-query 2025-11-18T09:00:36.516Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1019-optimization-cost-efficient-long-range-report-query 2025-02-14T15:23:23.806Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1027-optimization-better-queue-backlog-query 2024-06-13T17:43:01.949Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1031-optimization-better-refresh-strategy-query 2025-12-11T00:30:10.209Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1035-optimization-safer-backfill-rollout-strategy 2026-01-22T21:52:32.504Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/optimization/q-1040-optimization-better-progressive-rollout-query 2025-03-12T18:04:42.460Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/query-based 2025-12-02T05:36:09.189Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/query-based/q-1033-executive-architecture-scoreboard-query 2025-01-24T12:02:32.382Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based 2024-07-30T00:53:23.167Z weekly 0.8 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1001-global-commerce-data-platform-blueprint 2026-04-01T17:27:38.555Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1006-scenario-cdc-vs-batch-for-revenue-publishing 2024-11-26T01:46:17.054Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1008-scenario-contract-evolution-without-consumer-breakage 2024-12-01T00:40:33.527Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1009-scenario-active-active-payment-writes 2024-05-15T13:08:09.832Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1014-scenario-read-after-write-in-multi-region-api 2025-01-12T04:10:57.303Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1016-scenario-dr-drill-design-for-critical-ledger 2025-04-03T21:58:26.828Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1017-scenario-pii-residency-architecture 2024-11-25T05:58:02.972Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1022-scenario-retention-vs-legal-hold-conflict 2026-01-30T08:11:52.468Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1024-scenario-finops-guardrails-for-analytics-explosion 2025-07-14T16:38:17.837Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1025-scenario-noisy-neighbor-isolation-in-shared-cluster 2025-01-18T11:48:25.051Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1029-scenario-black-friday-auto-scaling-strategy 2025-05-25T09:53:58.559Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1032-scenario-hot-partition-mitigation-plan 2026-02-12T09:03:24.668Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1036-scenario-legacy-pipeline-retirement-plan 2025-01-25T12:22:04.798Z weekly 0.7 https://www.sql-practice.online/interview/level-10-master/scenario-based/q-1038-scenario-production-outage-command-for-data-plane 2024-07-25T20:28:03.627Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior 2025-05-13T09:43:14.482Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/debugging 2024-11-02T20:03:08.258Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/debugging/q-213-debugging-group-by-mismatch 2024-10-08T16:03:33.240Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/debugging/q-214-debugging-left-join-filter-trap 2024-10-13T00:54:47.033Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/descriptive 2024-03-24T01:42:11.594Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/descriptive/q-207-inner-join-vs-left-join 2024-01-30T11:03:31.937Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice 2024-08-25T03:09:18.462Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-208-mcq-correct-having-usage 2024-12-24T18:02:31.105Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-209-mcq-count-unique-customers 2024-04-17T20:39:19.003Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/multiple-choice/q-210-mcq-keep-all-customers 2025-12-28T14:41:33.516Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/optimization 2025-03-05T21:36:36.903Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/optimization/q-220-optimization-lite-date-filter-and-column-hygiene 2025-07-19T15:40:02.492Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/output-prediction 2024-04-20T22:34:12.974Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/output-prediction/q-215-output-above-average-orders 2026-03-06T15:33:22.500Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/output-prediction/q-216-output-left-join-unmatched-row 2025-07-17T01:59:35.000Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based 2024-02-15T07:55:58.311Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/query-based/q-201-customer-spend-summary 2026-01-31T14:58:40.243Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-202-find-customers-with-no-orders 2024-04-24T20:30:10.819Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-203-department-payroll-snapshot 2025-11-30T01:33:24.455Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-204-monthly-revenue-report-2025 2025-10-15T14:18:55.641Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-205-top-2-products-by-units-sold 2024-09-17T01:23:56.839Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/query-based/q-206-employee-and-manager-names 2025-12-01T08:33:07.235Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based 2026-04-16T17:06:50.910Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-217-scenario-renewal-risk-watchlist 2024-03-22T10:48:46.431Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-218-scenario-top-support-load-customers 2024-12-18T04:06:25.688Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/scenario-based/q-219-scenario-weekly-team-capacity-view 2026-04-02T12:47:04.851Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/true-false 2025-12-08T15:22:06.379Z weekly 0.8 https://www.sql-practice.online/interview/level-2-junior/true-false/q-211-true-false-count-and-null 2024-09-25T02:34:58.950Z weekly 0.7 https://www.sql-practice.online/interview/level-2-junior/true-false/q-212-true-false-aggregate-in-where 2025-06-06T11:19:18.310Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate 2025-02-22T15:15:09.063Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/communication-prompt 2026-02-12T02:37:38.557Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/communication-prompt/q-336-communication-explain-a-query-trade-off 2025-03-17T00:08:48.762Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging 2024-05-13T05:03:27.498Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-316-debugging-left-join-dropping-rows 2024-08-26T23:52:12.373Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-317-debugging-group-by-non-aggregated-column 2024-09-05T12:18:58.995Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-318-debugging-window-alias-in-where 2026-04-13T15:38:27.798Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-319-debugging-duplicate-explosion-in-join 2025-05-17T08:08:05.917Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/debugging/q-320-debugging-non-sargable-date-predicate 2024-05-19T13:21:41.720Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/descriptive 2025-07-19T22:22:31.774Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/descriptive/q-312-in-vs-exists 2024-08-31T12:06:16.232Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/descriptive/q-313-row-number-vs-rank-vs-dense-rank 2024-10-11T21:00:03.685Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/fill-in-blank 2025-09-13T03:51:24.433Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/fill-in-blank/q-335-fill-in-window-ranking-clause 2025-07-10T20:29:26.848Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/multiple-choice 2025-02-09T22:19:12.078Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/multiple-choice/q-314-mcq-top-1-order-per-customer 2025-01-27T06:41:39.199Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization 2025-06-09T10:35:41.059Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-331-optimization-date-predicate-and-projection 2025-09-25T22:54:38.269Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-332-optimization-exists-vs-join-for-presence-check 2025-01-13T06:25:58.292Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-333-optimization-pre-aggregate-before-join 2024-01-01T10:38:22.450Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/optimization/q-334-optimization-or-predicate-rewrite 2026-04-30T01:25:13.004Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction 2026-02-13T08:33:10.541Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-321-output-running-total 2025-08-15T08:03:04.593Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-322-output-rank-with-ties 2024-12-27T22:03:30.640Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-323-output-above-department-average-count 2024-01-23T15:11:03.004Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/output-prediction/q-324-output-unmatched-customer-count 2025-05-29T06:09:25.288Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based 2024-03-04T02:42:07.360Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-301-top-customers-by-90-day-revenue 2025-07-18T20:27:07.541Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-302-customer-first-order-and-order-count 2024-07-07T13:14:39.994Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-303-products-never-sold 2025-03-15T01:52:24.634Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-304-employees-above-department-average 2025-03-21T20:56:01.906Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-305-latest-order-per-customer 2025-04-17T14:40:47.046Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-306-daily-active-users-with-7-day-rolling-average 2026-03-10T03:33:34.879Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-307-category-conversion-rate 2025-06-28T20:56:16.823Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-308-duplicate-email-detection 2025-03-24T14:33:26.540Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-309-second-highest-salary-per-department 2025-11-28T16:20:12.657Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-310-orders-and-returned-item-count 2025-09-15T22:22:55.479Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/query-based/q-311-monthly-new-customers-and-cumulative-total 2026-04-15T01:05:51.675Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based 2024-06-17T08:01:19.234Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-325-scenario-failed-login-risk-alert 2025-03-22T18:12:21.458Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-326-scenario-low-stock-without-open-purchase-orders 2024-06-10T22:34:48.468Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-327-scenario-churn-risk-candidates 2024-03-31T09:48:59.613Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-328-scenario-first-touch-campaign-attribution 2025-04-24T14:43:28.668Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-329-scenario-sla-breach-dashboard 2026-05-01T00:47:54.501Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/scenario-based/q-330-scenario-order-payment-reconciliation 2024-06-18T17:12:15.571Z weekly 0.7 https://www.sql-practice.online/interview/level-3-intermediate/true-false 2025-02-20T11:19:06.002Z weekly 0.8 https://www.sql-practice.online/interview/level-3-intermediate/true-false/q-315-true-false-left-join-filter-semantics 2024-04-18T11:51:18.134Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level 2025-07-08T09:02:31.188Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt 2025-08-16T14:32:42.888Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt/q-449-communication-explain-top-n-per-group-strategy 2024-07-26T17:42:49.852Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/communication-prompt/q-450-communication-defend-cte-vs-temp-table-choice 2025-07-14T13:18:20.586Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging 2025-09-02T08:48:17.560Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-423-debug-window-alias-used-in-where 2025-10-21T19:12:01.669Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-424-debug-cte-missing-as-keyword 2024-08-08T06:54:21.658Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-425-debug-wrong-partition-in-running-total 2024-02-02T20:55:18.363Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-426-debug-duplicate-rows-after-cte-join 2025-01-12T13:02:53.615Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-427-debug-incorrect-lag-ordering 2025-09-22T05:10:12.305Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-428-debug-recursive-cte-without-stop-guard 2025-06-30T05:54:53.600Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/debugging/q-429-debug-non-sargable-filter-in-cte 2024-06-26T03:42:25.129Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive 2025-09-02T06:41:22.046Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-440-cte-vs-subquery-vs-temp-table 2025-05-23T18:39:30.370Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-441-window-frame-types 2025-04-21T03:06:50.847Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/descriptive/q-442-recursive-cte-design-principles 2025-05-16T06:30:45.494Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank 2025-02-14T06:56:46.969Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank/q-447-fillblank-running-total-frame 2024-02-03T05:34:28.887Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/fill-in-blank/q-448-fillblank-recursive-cte-keywords 2024-05-11T22:05:07.492Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice 2025-03-09T18:03:35.445Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice/q-443-mcq-correct-window-filtering 2025-08-04T12:53:14.458Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/multiple-choice/q-444-mcq-recursive-cte-components 2024-04-08T05:48:43.224Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization 2024-07-03T10:50:30.795Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-435-optimization-window-pre-filter 2024-07-03T07:54:14.763Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-436-optimization-top-n-per-group-strategy 2025-05-24T10:18:13.067Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-437-optimization-cte-materialization-risk 2025-10-16T06:41:27.563Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-438-optimization-recursive-cte-boundaries 2024-06-16T10:54:42.497Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/optimization/q-439-optimization-filter-placement-with-left-join 2026-04-14T23:12:46.122Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction 2025-08-18T19:20:00.395Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-430-output-running-revenue-at-day-3 2024-10-24T04:10:30.877Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-431-output-dense-rank-with-salary-ties 2025-07-30T22:30:49.979Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-432-output-previous-week-revenue 2026-03-30T18:51:56.992Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-433-output-top-2-per-category-count 2025-05-31T19:40:57.334Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/output-prediction/q-434-output-first-event-per-user 2025-12-22T19:58:38.539Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based 2026-05-09T12:33:23.412Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-401-top-3-products-per-month-window-rank 2024-04-24T05:33:30.164Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-402-users-active-in-consecutive-months 2026-05-15T03:11:28.522Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-403-latest-ticket-status-per-ticket 2025-02-22T23:56:54.614Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-404-running-account-balance 2026-04-04T17:55:01.937Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-405-days-to-first-purchase 2025-08-05T19:05:49.256Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-406-month-1-cohort-retention 2024-12-29T16:26:33.561Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-407-ntile-salary-banding-by-department 2026-04-17T10:25:42.176Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-408-customers-with-30-day-purchase-gap 2025-12-11T17:00:03.283Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-409-weekly-revenue-with-wow-delta 2026-05-09T05:36:51.319Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-410-cumulative-unique-customers-by-month 2026-04-02T01:36:51.272Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-411-department-median-salary-window-approach 2024-08-22T23:27:44.727Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-412-3-day-moving-average-orders 2025-01-30T10:22:29.725Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-413-daily-funnel-conversion-session-to-purchase 2025-05-14T21:11:08.972Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/query-based/q-414-top-2-categories-by-region 2025-06-04T03:54:48.435Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based 2025-08-03T16:26:22.471Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-415-fraud-spike-detection-hourly 2024-11-11T21:08:32.859Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-416-sla-breach-with-reopen-awareness 2024-09-05T08:34:24.819Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-417-inventory-forecast-risk 2026-02-08T10:47:06.449Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-418-subscription-downgrade-risk 2024-08-20T12:02:10.865Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-419-marketplace-seller-reliability 2025-04-28T06:06:12.757Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-420-first-response-time-by-agent 2024-03-23T08:03:15.075Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-421-experiment-lift-by-cohort-week 2025-12-27T11:25:15.804Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/scenario-based/q-422-finance-accrual-vs-cash-variance 2025-05-17T01:04:59.918Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/true-false 2025-06-09T22:08:29.088Z weekly 0.8 https://www.sql-practice.online/interview/level-4-mid-level/true-false/q-445-true-false-window-functions-in-where 2025-03-30T20:19:09.423Z weekly 0.7 https://www.sql-practice.online/interview/level-4-mid-level/true-false/q-446-true-false-range-and-duplicate-values 2026-01-24T09:59:51.688Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior 2024-09-23T22:29:24.382Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/communication-prompt 2025-01-16T00:59:51.589Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/communication-prompt/q-565-communication-defend-index-strategy 2024-12-31T11:28:47.802Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/communication-prompt/q-566-communication-explain-safe-migration-plan 2024-04-12T23:44:03.056Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging 2024-08-01T10:07:10.108Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/debugging/q-539-debug-invalid-check-constraint-logic 2024-07-23T11:26:52.476Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-540-debug-broken-composite-index-order 2025-08-15T02:41:39.563Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-541-debug-fk-added-without-supporting-index 2025-07-30T10:57:08.999Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-542-debug-partition-key-function-prevents-pruning 2024-08-26T02:48:01.502Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-543-debug-duplicate-rows-after-join 2025-06-18T04:06:10.895Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-544-debug-unsafe-drop-column-migration 2025-09-13T19:48:25.218Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-545-debug-misused-unique-constraint-for-soft-delete 2025-12-05T13:36:23.424Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/debugging/q-546-debug-slow-top-n-query 2025-10-28T01:23:34.991Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive 2024-07-15T17:23:30.598Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-547-explain-expand-contract-migration-strategy 2024-11-02T20:52:43.315Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-548-composite-index-design-heuristics 2024-08-04T10:26:07.124Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-549-partitioning-trade-offs 2025-08-24T07:13:43.876Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-550-materialized-view-refresh-strategy 2024-02-12T19:47:55.319Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/descriptive/q-551-ddl-governance-in-ci-cd 2026-02-15T12:47:15.649Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank 2024-01-17T01:35:25.160Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-562-fillblank-composite-index-ddl 2026-04-23T21:33:52.432Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-563-fillblank-add-foreign-key 2025-07-07T05:17:28.686Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/fill-in-blank/q-564-fillblank-partitioned-table-syntax 2025-09-01T04:43:33.578Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice 2024-05-29T23:52:23.396Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-552-mcq-best-index-for-query-pattern 2025-02-02T21:14:02.261Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-553-mcq-safe-not-null-migration 2024-01-09T01:21:45.891Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-554-mcq-partition-key-choice 2025-02-14T09:15:25.243Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/multiple-choice/q-555-mcq-fk-performance-requirement 2025-04-01T13:35:56.677Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization 2024-05-25T13:29:28.495Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/optimization/q-527-optimization-sargable-date-filter 2025-07-26T18:00:13.461Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-528-optimization-exists-vs-in-large-subquery 2024-12-13T10:42:50.046Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-529-optimization-left-join-filter-placement 2024-06-06T01:37:07.958Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-530-optimization-pre-aggregate-before-join 2025-04-05T00:42:13.408Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-531-optimization-distinct-vs-window-dedupe 2025-06-14T03:28:22.697Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-532-optimization-avoid-select-star-on-hot-path 2025-02-26T15:17:28.993Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-533-optimization-or-predicate-rewrite 2024-11-11T00:07:22.737Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-534-optimization-count-strategy 2025-04-16T12:56:15.654Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-535-optimization-anti-join-pattern 2024-07-30T07:58:22.952Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-536-optimization-batch-delete-strategy 2025-12-11T22:17:33.184Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-537-optimization-join-key-data-type-mismatch 2025-04-20T10:10:04.108Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/optimization/q-538-optimization-filter-before-window 2024-05-20T10:22:59.935Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction 2025-07-09T05:02:14.587Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-559-output-composite-index-usability 2026-04-27T12:36:16.751Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-560-output-dedupe-keep-latest 2026-02-16T07:36:16.698Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/output-prediction/q-561-output-partial-unique-constraint 2025-06-24T10:01:59.092Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based 2024-09-04T07:01:30.327Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/query-based/q-501-design-orders-table-for-production 2026-03-25T23:11:05.278Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-502-safe-add-not-null-column-with-backfill 2024-02-17T12:45:07.091Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-503-create-idempotent-index-migration 2026-02-28T05:07:15.032Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-504-partition-event-table-by-month 2025-05-25T18:40:26.020Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-505-add-unique-constraint-after-data-cleanup 2024-02-25T03:20:00.534Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-506-build-rollup-table-for-dashboard 2024-06-05T23:04:40.388Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-507-create-covering-index-for-ticket-search 2024-01-16T23:52:24.958Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-508-online-rename-strategy-via-view-shield 2026-05-04T19:02:59.220Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-509-create-foreign-key-with-action-rules 2024-12-22T01:25:17.109Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-510-materialized-view-for-monthly-kpis 2024-05-03T09:32:17.488Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-511-build-partial-index-for-hot-subset 2025-06-17T23:25:22.155Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-512-implement-soft-delete-with-constraint-safety 2024-04-01T06:08:45.408Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-513-backfill-surrogate-key-safely 2025-10-10T23:03:40.610Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/query-based/q-514-create-historical-archive-table 2025-05-16T11:23:13.550Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based 2024-01-29T22:11:53.883Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-515-scenario-zero-downtime-add-enum-like-status 2025-11-08T14:06:45.679Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-516-scenario-fast-tenant-purge 2025-02-10T19:43:52.142Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-517-scenario-add-fk-to-dirty-legacy-data 2025-08-30T03:54:39.200Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-518-scenario-migration-from-int-to-bigint-pk 2026-02-25T23:22:07.619Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-519-scenario-hotfix-for-blocking-ddl 2025-02-15T03:09:32.280Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-520-scenario-enforce-exactly-one-primary-address 2024-05-26T00:58:10.461Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-521-scenario-daily-incremental-aggregate-refresh 2026-03-16T18:01:32.085Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-522-scenario-guard-against-negative-inventory 2025-05-30T11:28:15.873Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-523-scenario-partition-pruning-failure 2025-03-15T15:28:48.316Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-524-scenario-introduce-multi-column-business-key 2024-02-18T01:50:13.619Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-525-scenario-recover-from-dropped-index 2025-09-01T04:46:30.723Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/scenario-based/q-526-scenario-split-monolithic-table 2025-04-01T04:06:10.853Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false 2024-10-06T11:57:41.361Z weekly 0.8 https://www.sql-practice.online/interview/level-5-senior/true-false/q-556-true-false-not-in-with-nulls 2025-04-13T15:31:51.924Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false/q-557-true-false-concurrent-index-build 2025-09-07T09:46:45.932Z weekly 0.7 https://www.sql-practice.online/interview/level-5-senior/true-false/q-558-true-false-function-on-indexed-column 2025-10-23T12:32:32.801Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert 2024-07-31T13:26:50.211Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/communication-prompt 2025-07-20T09:48:31.763Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-609-explain-why-you-chose-a-history-table 2024-09-28T16:38:20.478Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-610-defend-composite-uniqueness-strategy 2025-12-12T17:43:28.697Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-640-explain-why-atomic-update-beats-read-then-write 2025-11-18T17:16:11.253Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-641-defend-transactional-outbox 2024-06-17T15:59:48.694Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-657-explain-multi-tenant-choice-to-interviewer 2024-09-08T22:53:36.668Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-658-defend-event-sourcing-vs-snapshot-only 2024-06-21T18:39:21.479Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-672-explain-your-rollback-plan 2025-10-19T08:33:42.082Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/communication-prompt/q-673-defend-why-you-delay-column-drop 2025-03-28T15:19:05.380Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging 2025-10-29T20:16:22.372Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/debugging/q-611-fix-non-deterministic-current-plan-query 2025-06-22T19:23:34.868Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-612-repair-overlapping-temporal-ranges 2025-09-17T21:44:01.866Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-625-debugging-non-sargable-date-predicate 2024-10-14T20:28:13.411Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-626-debugging-wrong-index-column-order 2026-05-17T14:44:17.946Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-642-debugging-lost-update-pattern 2026-03-23T06:16:04.622Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-643-debugging-duplicate-idempotency-key-inserts 2024-03-19T15:15:14.987Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-644-debugging-orphan-child-rows 2025-02-06T06:17:21.978Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-661-debugging-double-counting-revenue 2026-03-01T23:04:09.046Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-678-debugging-breaking-migration-order 2025-10-16T07:45:45.059Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/debugging/q-679-debugging-unsafe-destructive-change 2025-07-06T14:43:05.515Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive 2026-02-08T13:55:47.425Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-601-oltp-normalization-vs-read-model-denormalization 2025-06-21T19:17:38.340Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-602-surrogate-key-vs-natural-key-at-scale 2024-11-28T20:03:01.878Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-603-temporal-modeling-for-customer-plans 2024-05-03T21:07:09.744Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-604-soft-delete-vs-archive-table 2024-07-03T03:35:24.399Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-632-composite-index-prefix-strategy 2024-09-18T05:59:14.384Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-633-isolation-level-trade-off-for-checkout 2026-02-18T04:22:04.649Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-634-idempotency-in-payment-write-path 2025-06-27T01:22:10.235Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-635-deferrable-constraint-use-case 2026-01-06T20:03:35.874Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-649-e-commerce-order-domain-boundaries 2025-06-01T18:30:41.200Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-650-fintech-ledger-vs-balance-table 2025-09-19T07:03:22.462Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-651-multi-tenant-isolation-models 2026-03-11T08:42:26.037Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-665-expand-contract-migration-strategy 2024-01-06T18:13:32.585Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-666-backfill-risk-controls 2025-09-06T17:19:37.214Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/descriptive/q-667-backward-compatibility-in-api-db-evolution 2025-01-01T06:13:18.625Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/fill-in-blank 2024-02-22T17:13:21.597Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/fill-in-blank/q-680-fillblank-add-safe-constraint 2025-03-20T22:01:20.030Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/module/m1-data-modeling 2025-05-15T16:51:23.590Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m2-performance-schema 2025-04-16T06:28:45.110Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m3-consistency-integrity 2026-05-11T08:21:03.473Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m4-domain-design-cases 2026-01-03T01:57:58.513Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/module/m5-schema-evolution 2024-12-05T00:12:02.770Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/multiple-choice 2025-11-03T14:27:47.276Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-614-mcq-best-key-strategy-for-user-profile 2025-05-06T15:47:21.432Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-629-mcq-best-index-for-query-pattern 2024-08-21T02:06:42.396Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-646-mcq-best-pattern-for-exactly-once-business-effect 2024-03-29T23:16:17.624Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/multiple-choice/q-664-mcq-best-multi-tenant-uniqueness-constraint 2025-09-13T23:15:08.037Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization 2025-10-12T20:00:55.658Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/optimization/q-617-optimization-partition-pruning-candidate 2026-04-22T03:45:19.377Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-618-optimization-covering-index-friendly-query 2024-08-02T08:36:23.671Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-619-optimization-sargable-status-filter 2024-10-10T14:34:14.670Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-620-optimization-top-n-per-group-pattern 2024-06-18T22:54:20.216Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-621-optimization-exists-vs-distinct-join 2026-04-29T01:32:45.220Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-648-optimization-conflict-handling-path 2025-03-04T12:05:57.231Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-659-optimization-cohort-query-pattern 2024-07-24T07:42:44.365Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-660-optimization-anti-join-for-churn-candidates 2025-09-06T11:58:05.963Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-674-optimization-safer-migration-write-path 2025-05-10T17:21:35.338Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-675-optimization-batch-backfill-pattern 2025-10-25T07:58:16.594Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-676-optimization-contract-phase-safety 2024-05-02T13:17:30.292Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/optimization/q-677-optimization-index-migration-sequence 2024-02-04T16:18:43.392Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction 2025-05-10T22:04:11.990Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-613-output-identify-duplicate-natural-key 2024-08-12T18:15:21.743Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-627-output-partition-range-match-count 2024-06-17T11:59:48.573Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-628-output-covering-style-projection 2025-11-10T00:13:38.229Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-645-output-idempotency-unique-constraint-effect 2025-03-09T17:06:05.872Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-662-output-first-touch-attribution-result 2024-08-30T13:25:54.717Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/output-prediction/q-663-output-breach-count-calculation 2025-03-08T13:24:15.951Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/query-based 2024-07-04T02:28:30.848Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/query-based/q-616-ddl-append-only-ledger-entry-table 2025-08-02T10:16:22.740Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/query-based/q-631-query-top-tenants-by-7-day-write-volume 2024-09-30T11:47:13.083Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based 2026-03-17T04:57:57.076Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-605-schema-for-product-variant-catalog 2026-01-26T04:53:56.774Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-606-audit-ready-payment-state-model 2024-06-15T20:24:27.061Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-607-reference-data-governance-model 2025-12-26T05:58:11.672Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-608-identity-and-alias-resolution 2024-04-07T06:36:32.685Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-622-scenario-time-series-event-storage 2025-06-05T08:09:06.085Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-623-scenario-hot-cold-order-table-split 2026-05-10T07:44:07.497Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-624-scenario-multi-column-index-choice 2026-01-23T11:14:58.225Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-636-scenario-idempotent-job-execution-table 2024-08-08T03:27:03.043Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-637-scenario-enforce-non-negative-inventory-updates 2024-03-16T21:34:47.936Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-638-scenario-parent-child-integrity-with-soft-delete 2025-12-07T02:19:26.954Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-639-scenario-transactional-outbox-schema 2024-09-20T01:29:24.775Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-652-scenario-saas-tenant-usage-metering 2024-04-14T06:18:37.613Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-653-scenario-fraud-rule-evaluation-trace 2025-11-22T01:29:53.893Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-654-scenario-marketplace-settlement-model 2025-07-21T00:33:01.904Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-655-scenario-analytics-attribution-first-touch 2025-07-15T23:16:47.154Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-656-scenario-sla-breach-dashboard-by-team 2024-10-19T19:44:40.569Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-668-scenario-add-non-null-column-safely 2025-05-08T10:35:48.366Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-669-scenario-introduce-new-status-enum-values 2024-05-25T03:02:33.938Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-670-scenario-rebuild-index-online 2024-02-27T04:31:44.706Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/scenario-based/q-671-scenario-split-monolithic-address-column 2024-08-31T21:27:28.919Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false 2026-03-21T18:08:41.285Z weekly 0.8 https://www.sql-practice.online/interview/level-6-expert/true-false/q-615-true-false-3nf-is-always-slower 2024-08-25T12:06:04.212Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false/q-630-true-false-select-is-neutral 2025-01-23T19:09:03.450Z weekly 0.7 https://www.sql-practice.online/interview/level-6-expert/true-false/q-647-true-false-retry-without-idempotency-is-safe 2025-02-06T10:57:48.961Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect 2024-03-11T17:30:33.278Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/communication-prompt 2026-02-02T14:05:05.636Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-761-explain-model-choice-to-vp-of-analytics 2026-03-21T03:57:39.567Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-766-explain-freshness-vs-cost-trade-off 2025-06-03T16:21:48.603Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-776-explain-incident-plan-to-sre-during-latency-spike 2025-12-02T07:08:11.679Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/communication-prompt/q-785-explain-rollback-decision-under-incident-pressure 2025-08-06T07:13:18.433Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging 2024-06-02T01:17:26.847Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/debugging/q-703-debug-non-sargable-email-lookup 2024-06-19T04:45:18.407Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-710-debug-leading-wildcard-search 2025-05-20T05:06:05.156Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-717-debug-or-predicate-that-defeats-index-path 2025-06-22T08:56:31.670Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-727-debug-distinct-masking-join-explosion 2024-12-21T10:11:46.986Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-731-debug-correlated-subquery-re-execution-cost 2025-05-20T16:39:11.418Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-736-debug-unnecessary-order-by-in-subquery 2026-02-13T12:21:09.280Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-747-debug-cast-preventing-partition-pruning 2025-04-25T02:29:49.135Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-755-debug-non-prunable-between-on-timestamp-boundaries 2026-05-17T14:29:31.496Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-771-debug-plan-regression-from-stale-statistics 2025-11-27T20:59:13.001Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-775-debug-implicit-type-conversion-causing-scan 2026-01-19T19:00:32.064Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-778-debug-hash-join-spill-to-disk 2024-10-31T19:19:09.504Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-781-debug-lock-contention-from-long-transaction 2024-08-31T02:59:49.210Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-784-debug-nested-loop-explosion-on-large-join 2026-01-07T22:11:59.939Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/debugging/q-787-debug-high-rows-removed-by-filter 2024-03-11T07:33:58.870Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive 2026-03-23T05:18:57.232Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-718-b-tree-vs-hash-vs-full-text-index-decision 2024-02-14T18:44:43.563Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-738-cte-vs-temp-table-decision-in-performance-tuning 2024-07-28T15:44:56.024Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-745-range-vs-hash-partitioning-trade-off 2024-08-16T17:34:04.430Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-752-when-to-subpartition-by-tenant 2025-08-30T16:47:01.157Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-758-fact-grain-decision-and-performance-impact 2025-10-04T16:17:03.561Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-763-conformed-dimensions-in-multi-domain-analytics 2024-07-24T05:41:52.418Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/descriptive/q-769-snapshot-fact-vs-transaction-fact 2024-04-07T16:47:34.574Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/fill-in-blank 2025-07-14T19:49:34.690Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/fill-in-blank/q-734-fillblank-keyset-pagination-predicate 2024-11-04T02:16:45.654Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/module/m1-indexing-strategy 2024-12-21T22:58:07.453Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m2-query-shape-optimization 2024-02-18T16:31:09.951Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m3-partitioning-lifecycle 2024-04-09T09:05:06.822Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m4-dimensional-performance-models 2024-01-15T03:12:54.676Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/module/m5-plan-forensics-production-tuning 2024-11-10T17:45:22.800Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/multiple-choice 2026-04-01T07:08:08.092Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/multiple-choice/q-721-mcq-best-composite-index-for-recent-paid-orders 2024-06-28T03:29:46.259Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/multiple-choice/q-790-mcq-first-response-to-sudden-query-regression 2024-10-25T14:15:30.136Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization 2024-03-12T07:50:14.673Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/optimization/q-705-optimization-showdown-active-users-lookup 2025-12-27T03:27:16.542Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-709-optimization-showdown-keyset-vs-offset-pagination 2025-11-19T01:59:51.509Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-714-optimization-showdown-covering-projection 2025-10-29T10:16:41.894Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-720-optimization-showdown-function-index-trade-off 2025-01-13T12:41:42.488Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-726-optimization-showdown-anti-join-pattern 2024-04-28T05:17:38.040Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-730-optimization-showdown-union-vs-union-all 2024-08-17T11:26:09.550Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-739-optimization-showdown-in-vs-exists-for-large-subquery 2025-02-28T23:54:32.397Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-743-optimization-showdown-partition-prunable-predicate 2025-11-24T01:12:57.315Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-748-optimization-showdown-local-vs-global-index-filter 2025-02-16T03:12:47.108Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-753-optimization-showdown-retention-job-shape 2025-04-02T05:24:30.471Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-764-optimization-showdown-raw-fact-vs-aggregate-table 2026-01-11T21:27:48.595Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-772-optimization-showdown-parameter-sniffing-mitigation 2024-09-09T14:43:46.203Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-777-optimization-showdown-chunked-backfill-vs-single-massive-update 2025-01-31T08:29:13.747Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-782-optimization-showdown-leading-table-in-join-order 2025-05-12T12:28:19.981Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-786-optimization-showdown-seek-friendly-date-window 2026-02-08T13:51:13.458Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/optimization/q-789-optimization-showdown-covering-index-for-sort-filter 2026-01-26T06:25:51.496Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction 2025-10-07T08:52:12.630Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-713-output-which-candidate-is-more-index-friendly 2024-12-09T19:37:49.442Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-729-output-exists-vs-join-distinct-row-semantics 2025-09-18T10:08:49.623Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-737-output-count-after-inner-join-with-missing-matches 2024-09-30T22:17:05.742Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-756-output-partition-scan-count 2026-03-20T06:15:57.382Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/output-prediction/q-768-output-star-join-row-multiplication 2026-02-02T22:50:55.309Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based 2024-06-28T00:59:43.433Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/query-based/q-701-top-slow-endpoints-by-p95-in-last-7-days 2025-01-05T07:40:19.524Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-702-partition-pruned-monthly-revenue-query 2024-01-18T13:54:10.446Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-706-covering-index-candidate-for-recent-paid-orders 2025-02-27T01:12:42.901Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-707-partial-index-friendly-subscription-scan 2026-02-23T05:10:57.104Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-708-composite-index-aligned-queue-fetch 2026-01-28T00:25:21.355Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-712-index-safe-last-login-dashboard-query 2025-10-05T12:54:42.094Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-716-top-n-by-composite-sort-for-fraud-queue 2025-05-17T00:52:43.075Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-719-index-only-candidate-for-comment-feed 2026-03-18T03:09:45.792Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-723-exists-for-active-customers-in-last-30-days 2025-11-11T21:25:20.361Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-724-top-3-orders-per-customer-window-shape 2025-07-08T10:40:26.791Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-725-predicate-pushdown-before-heavy-join 2025-07-27T14:51:56.034Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-728-pre-aggregate-before-joining-large-dimensions 2025-12-30T04:45:51.847Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-732-semi-join-for-recently-active-products 2024-05-25T14:11:51.188Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-735-shape-query-for-top-categories-by-revenue 2025-10-31T11:07:21.525Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-740-rewrite-optional-filter-query-without-coalesce-trap 2024-04-09T01:54:44.792Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-744-partition-friendly-weekly-revenue-query 2024-02-09T09:10:49.439Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-749-monthly-partition-revenue-by-tenant 2025-08-08T11:46:56.167Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-751-partition-metadata-driven-retention-sql 2025-03-09T22:28:26.521Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-760-star-query-monthly-revenue-by-region 2025-11-12T05:48:40.447Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-765-top-products-by-revenue-in-star-model 2026-03-28T15:42:49.327Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-774-find-top-cpu-queries-in-last-hour 2026-03-09T13:04:57.991Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-780-query-plans-with-high-temp-spill 2024-09-24T20:39:26.607Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/query-based/q-788-find-worst-fingerprints-by-p99-latency-regression 2025-09-29T21:19:28.623Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based 2026-03-03T02:12:11.175Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-704-scenario-multi-tenant-events-index-strategy 2024-08-11T04:42:15.808Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-711-scenario-index-budget-on-write-heavy-ledger 2024-03-23T06:34:53.200Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-715-scenario-geo-search-and-secondary-index-choice 2025-12-04T19:03:17.060Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-733-scenario-query-shape-for-multi-widget-dashboard 2025-06-10T15:09:48.676Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-741-scenario-partition-key-choice-for-orders-at-10b-rows 2025-06-14T01:28:01.978Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-742-scenario-retention-deletes-vs-partition-drops 2024-08-16T09:30:39.018Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-746-scenario-hot-cold-storage-split-strategy 2025-10-29T21:10:14.526Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-750-scenario-multi-tenant-partitioning-by-time-tenant 2024-02-22T23:07:22.346Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-754-scenario-backfill-new-partition-key-without-downtime 2024-03-27T08:52:16.382Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-757-scenario-star-vs-snowflake-for-self-serve-bi 2025-11-22T01:55:17.050Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-759-scenario-scd2-dimension-join-performance 2025-12-15T03:51:31.392Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-762-scenario-late-arriving-facts-handling 2024-02-02T22:33:21.193Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-767-scenario-bridge-table-for-many-to-many-attribution 2025-11-02T00:29:48.366Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-770-scenario-semantic-layer-and-sql-performance 2024-10-31T19:56:39.612Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-773-scenario-production-tuning-rollout-guardrails 2024-06-21T15:24:57.507Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-779-scenario-read-replica-offload-without-stale-kpi-risk 2025-03-13T11:44:08.820Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/scenario-based/q-783-scenario-plan-instability-across-deployments 2025-09-28T15:34:38.513Z weekly 0.7 https://www.sql-practice.online/interview/level-7-architect/true-false 2024-03-26T22:55:10.999Z weekly 0.8 https://www.sql-practice.online/interview/level-7-architect/true-false/q-722-true-false-more-indexes-always-means-better-performance 2025-08-06T04:20:20.121Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal 2025-10-15T03:14:33.487Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/communication-prompt 2026-02-11T22:17:08.311Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-820-60-second-defense-shard-key-decision 2024-11-27T00:53:41.044Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-842-60-second-consistency-choice 2024-03-08T19:22:30.525Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-860-60-second-failover-trade-off-explanation 2024-06-23T23:31:14.680Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-880-60-second-cdc-correctness-narrative 2024-04-21T07:09:32.298Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-895-60-second-multi-region-architecture-pitch 2024-04-22T04:51:50.334Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-896-60-second-incident-governance-update 2026-04-08T10:48:48.959Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-897-60-second-cost-reduction-story 2025-05-20T22:19:39.698Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-898-60-second-residency-audit-readiness 2024-12-20T11:20:47.293Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-899-60-second-quorum-cost-justification 2024-08-07T06:57:09.380Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/communication-prompt/q-900-60-second-global-schema-rollout 2025-08-23T04:43:15.032Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging 2025-05-11T15:14:48.387Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/debugging/q-804-debug-cast-on-shard-key 2025-11-15T14:51:04.728Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-805-debug-missing-tenant-predicate 2024-08-27T20:47:56.368Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-828-debug-missing-group-by-in-settlement 2025-05-14T11:25:47.613Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-829-debug-retry-dedupe-predicate 2025-04-08T04:44:23.671Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-830-debug-negative-inventory-risk 2025-07-23T15:08:25.091Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-831-debug-replay-ordering 2024-03-05T07:05:42.557Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-850-debug-region-filter-precedence 2026-04-01T10:45:39.778Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-851-debug-failover-candidate-ordering 2024-02-25T16:06:44.984Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-852-debug-missing-health-constraint 2026-02-15T13:29:59.371Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-868-debug-invalid-latest-row-aggregation 2024-03-01T06:15:59.808Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-869-debug-late-event-window-filter 2026-04-23T09:22:35.113Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/debugging/q-885-debug-region-filter-in-cost-query 2025-10-27T10:21:22.658Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive 2024-09-07T23:56:25.422Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-815-consistent-hashing-vs-range-sharding 2024-11-06T01:12:21.632Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-816-ownership-boundaries-to-avoid-global-transactions 2025-09-07T17:30:20.887Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-817-replicate-small-dimensions-vs-cross-shard-join 2024-03-02T16:04:32.244Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-822-saga-vs-2pc-trade-off 2024-09-19T15:37:20.508Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-823-idempotency-key-enforcement 2025-08-31T08:19:41.524Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-824-isolation-choice-for-inventory-reservation 2025-10-12T07:04:00.755Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-825-why-transactional-outbox-works 2026-05-04T07:10:17.554Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-844-rpo-and-rto-in-design-decisions 2025-07-18T03:40:01.509Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-845-async-vs-sync-replication-decision 2024-04-02T14:03:14.198Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-846-split-brain-prevention-controls 2025-02-07T03:47:54.470Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-847-read-after-write-in-replica-topologies 2024-10-12T18:23:25.865Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-863-exactly-once-vs-at-least-once-semantics 2025-07-28T00:04:26.106Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-864-global-vs-per-key-ordering 2026-04-17T16:46:21.034Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-865-backpressure-control-plan 2026-01-26T18:05:59.738Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-866-safe-replay-strategy 2024-08-16T06:06:44.467Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-882-latency-vs-cost-in-multi-region-writes 2024-03-14T00:22:35.559Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-883-data-residency-enforcement-controls 2025-11-22T03:21:23.918Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/descriptive/q-884-capacity-planning-leading-indicators 2024-01-25T06:58:19.269Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank 2024-11-27T04:45:04.049Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank/q-841-fillblank-conflict-no-op-clause 2024-04-10T03:07:39.530Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/fill-in-blank/q-879-fillblank-window-ordering-token 2026-02-22T17:20:12.990Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/module/m1-distributed-data-architecture 2025-10-25T08:49:57.085Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m2-consistency-transactions-scale 2024-01-18T01:21:03.457Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m3-replication-ha-dr 2025-09-26T06:01:59.524Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m4-streaming-cdc-events 2025-11-07T20:34:57.876Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/module/m5-multi-region-cost-governance 2026-03-05T10:34:33.592Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/multiple-choice 2026-03-16T09:29:39.508Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-819-mcq-best-shard-key-characteristic 2025-06-23T01:51:27.078Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-826-mcq-duplicate-charge-prevention 2024-03-11T04:41:48.182Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-848-mcq-safest-promotion-signal 2025-12-12T14:36:10.595Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/multiple-choice/q-867-mcq-best-cdc-dedup-key 2024-04-01T03:36:09.286Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization 2024-06-17T00:43:14.515Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/optimization/q-811-optimization-date-vs-range-on-partition-key 2026-05-18T03:03:40.633Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-812-optimization-routed-join 2025-07-20T12:30:49.334Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-813-optimization-composite-index-column-order 2024-08-04T20:33:03.644Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-814-optimization-uuid-vs-ordered-ids 2024-07-01T11:11:08.144Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-839-optimization-idempotent-insert-pattern 2024-11-13T21:54:13.575Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-840-optimization-atomic-stock-decrement 2025-03-10T20:30:50.514Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-858-optimization-freshness-predicate-form 2024-08-20T02:05:46.861Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-859-optimization-region-health-dashboard-query 2025-10-05T12:34:01.731Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-877-optimization-distinct-vs-window-dedup 2025-08-24T08:20:31.304Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-878-optimization-full-recompute-vs-incremental 2024-04-12T09:51:55.874Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-891-optimization-read-routing-policy 2026-01-17T22:33:40.886Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-892-optimization-storage-tiering-strategy 2024-08-09T05:09:17.561Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-893-optimization-multi-region-index-policy 2025-09-05T18:26:48.111Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/optimization/q-894-optimization-governance-enforcement-mechanism 2025-06-12T03:55:11.816Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction 2024-03-08T11:43:04.443Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-818-output-routed-or-broadcast 2024-07-11T14:55:26.507Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-832-output-locking-pattern-for-lost-update 2024-09-09T13:04:53.761Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-853-output-promote-or-wait-decision 2026-01-16T06:56:17.475Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-870-output-deduped-version-count 2026-04-09T18:21:46.262Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-871-output-watermark-admission 2024-05-31T21:38:55.323Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/output-prediction/q-886-output-budget-alert-trigger 2024-01-31T20:19:02.757Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based 2025-07-25T06:42:56.929Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/query-based/q-801-tenant-checkout-feed-in-last-7-days 2024-01-28T17:47:19.257Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-802-single-shard-active-session-pull 2025-09-04T23:35:01.163Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-803-region-partition-product-reads 2024-07-03T03:42:39.575Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-821-outbox-polling-window 2026-03-21T08:42:41.706Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-843-replica-lag-breach-query 2024-03-21T19:55:51.939Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-861-latest-version-per-customer-from-cdc 2024-04-18T03:05:59.440Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-862-ingestion-lag-by-pipeline 2024-08-25T04:30:04.912Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/query-based/q-881-cross-region-storage-cost-top-services 2024-01-10T08:00:00.684Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based 2024-06-20T08:15:30.439Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-806-shard-key-choice-for-marketplace-orders 2026-02-23T12:51:21.068Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-807-zero-downtime-re-sharding-plan 2024-10-03T22:16:49.524Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-808-noisy-neighbor-isolation-without-replatform 2026-02-12T06:08:39.838Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-809-global-id-strategy-across-regions 2025-03-25T15:45:43.311Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-810-reference-data-placement-strategy 2025-05-07T05:55:41.501Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-833-payment-success-but-inventory-fail 2026-04-22T16:05:09.478Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-834-duplicate-event-consumption 2025-05-09T14:30:31.583Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-835-hot-counter-correctness 2024-09-03T04:40:32.479Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-836-reservation-timeout-release-flow 2024-02-08T04:15:51.251Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-837-per-aggregate-ordering-under-partitioned-streams 2024-04-25T05:16:59.507Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-838-fast-ux-with-reliable-side-effects 2024-02-04T02:35:39.683Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-854-regional-outage-failover-sequence 2025-12-01T01:04:34.364Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-855-read-routing-during-lag-spikes 2025-11-13T00:42:32.537Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-856-disaster-recovery-drill-design 2025-03-26T00:17:24.179Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-857-cross-region-quorum-strategy 2025-04-04T16:34:23.789Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-872-reliable-db-kafka-write-pattern 2026-04-14T16:57:32.118Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-873-late-event-revenue-corrections 2024-08-18T20:39:31.060Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-874-exactly-once-sink-to-warehouse 2026-03-01T05:50:01.439Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-875-poison-message-policy 2024-02-03T09:53:58.757Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-876-event-contract-evolution-rollout 2026-02-25T04:42:42.867Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-887-topology-decision-for-global-checkout 2025-10-11T09:46:56.848Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-888-cross-region-egress-spike-response 2025-07-09T06:28:07.234Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-889-compliance-aware-dr-failover 2024-12-01T12:14:45.307Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/scenario-based/q-890-cost-performance-governance-model 2025-03-29T22:52:53.515Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/true-false 2024-11-02T02:33:17.635Z weekly 0.8 https://www.sql-practice.online/interview/level-8-principal/true-false/q-827-true-false-eventual-consistency-implies-data-loss 2025-08-03T12:00:35.185Z weekly 0.7 https://www.sql-practice.online/interview/level-8-principal/true-false/q-849-true-false-async-replication-zero-loss 2024-11-08T23:14:32.300Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished 2024-04-17T15:30:24.940Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/debugging 2026-03-31T08:12:43.402Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-903-debug-function-wrapped-predicate 2025-10-05T13:39:57.852Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-914-debug-heap-fetch-heavy-read 2025-11-06T19:22:34.187Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-921-debug-opposite-lock-ordering 2024-05-14T06:49:42.901Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-926-debug-missing-predicate-lock-scope 2024-03-15T09:56:27.192Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-932-debug-read-after-write-staleness 2024-09-05T19:16:58.482Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/debugging/q-942-debug-unbounded-cross-shard-fan-out 2025-09-07T09:13:42.412Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive 2024-06-08T06:31:36.077Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-902-cardinality-misestimation-and-wrong-join-plans 2024-06-17T01:26:17.850Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-906-stale-stats-vs-histogram-quality 2024-07-11T23:55:28.070Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-910-nested-loop-vs-hash-join-trade-off 2024-04-09T20:42:07.591Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-911-mvcc-bloat-and-cleanup-strategy 2024-03-15T11:54:41.919Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-916-covering-index-vs-heap-lookup-trade-off 2026-01-16T23:14:48.029Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-919-hot-updates-and-fillfactor 2025-12-05T01:14:56.541Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-920-isolation-levels-and-anomaly-prevention 2024-11-08T23:11:20.471Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-925-preventing-phantom-like-business-violations 2024-03-18T02:22:10.861Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-931-rpo-rto-trade-offs-for-critical-workloads 2026-02-08T06:36:09.726Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-936-read-consistency-contract-across-failover 2025-05-13T00:15:02.662Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-940-shard-key-evolution-strategy 2025-08-27T03:09:26.938Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/descriptive/q-941-consistency-model-for-user-wallet 2024-06-15T05:30:59.899Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/module/m1-optimizer-cardinality-internals 2025-12-14T01:57:24.104Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m2-storage-index-mvcc-internals 2025-02-25T18:03:29.217Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m3-concurrency-isolation-deadlocks 2025-07-25T08:44:32.708Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m4-replication-recovery-failover 2025-11-28T01:54:54.336Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/module/m5-distributed-sql-sharding-consistency 2024-02-26T05:47:54.782Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/optimization 2025-05-06T22:06:40.888Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-905-optimization-date-function-vs-range-predicate 2025-02-25T17:58:05.426Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-909-optimization-late-filter-vs-early-filter 2026-01-17T12:07:53.536Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-913-optimization-function-index-vs-plain-predicate 2024-03-07T03:01:03.301Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-918-optimization-composite-index-column-order 2025-01-13T13:24:39.521Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-930-optimization-replica-safe-daily-paid-orders 2024-03-29T07:40:36.515Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-935-optimization-commit-mode-for-payment-writes 2025-04-20T03:02:44.461Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-944-optimization-routed-query-vs-global-query 2024-08-06T08:05:12.331Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/optimization/q-945-optimization-global-index-vs-local-lookup 2025-03-14T04:16:43.143Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction 2026-03-03T09:41:00.481Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction/q-923-output-deadlock-victim-result 2025-01-14T09:12:04.218Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/output-prediction/q-933-output-pitr-target-semantics 2024-06-30T02:05:00.860Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based 2024-11-25T00:27:04.374Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-901-top-failed-merchants-in-last-24-hours 2024-05-30T01:10:22.124Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-907-selectivity-probe-for-fraud-rules 2026-05-09T14:48:47.688Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-912-latest-active-catalog-version 2024-07-05T16:56:01.772Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-917-version-chain-head-query 2025-06-22T08:11:00.891Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-924-find-long-running-open-transactions 2025-09-02T09:25:44.386Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-938-shard-local-balance-snapshot 2024-05-15T21:07:33.701Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/query-based/q-939-cross-shard-transaction-frequency 2025-04-19T12:34:22.867Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based 2024-04-21T07:49:52.893Z weekly 0.8 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-904-join-explosion-in-revenue-rollup 2025-10-27T21:21:43.683Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-908-plan-instability-from-parameter-sniffing 2024-02-14T06:23:02.613Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-915-vacuum-backlog-under-write-bursts 2024-11-26T18:43:28.272Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-922-retry-and-idempotency-for-deadlock-victims 2026-01-14T15:02:33.371Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-927-contention-control-in-flash-sale-checkout 2026-02-28T03:27:50.751Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-928-isolation-choice-for-mixed-oltp-analytics 2024-07-08T19:02:12.622Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-929-failover-runbook-after-region-outage 2024-12-08T17:43:51.671Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-934-backup-restore-validation-plan 2024-05-24T18:13:39.948Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-937-split-brain-prevention-controls 2026-01-10T02:19:44.040Z weekly 0.7 https://www.sql-practice.online/interview/level-9-distinguished/scenario-based/q-943-hot-shard-rebalancing-plan 2026-03-25T14:12:44.416Z weekly 0.7 https://www.sql-practice.online/interview/topic/acid-properties 2024-11-24T04:36:34.221Z weekly 0.8 https://www.sql-practice.online/interview/topic/aggregations 2025-04-24T11:25:08.971Z weekly 0.8 https://www.sql-practice.online/interview/topic/ctes 2024-01-30T22:57:21.246Z weekly 0.8 https://www.sql-practice.online/interview/topic/database-design 2025-02-20T20:10:58.705Z weekly 0.8 https://www.sql-practice.online/interview/topic/indexing 2024-10-03T14:35:40.863Z weekly 0.8 https://www.sql-practice.online/interview/topic/joins-and-relationships 2024-04-24T15:54:45.218Z weekly 0.8 https://www.sql-practice.online/interview/topic/normalization 2026-05-15T09:35:33.894Z weekly 0.8 https://www.sql-practice.online/interview/topic/performance-tuning 2025-06-02T03:10:50.858Z weekly 0.8 https://www.sql-practice.online/interview/topic/query-optimization 2024-04-23T15:42:02.464Z weekly 0.8 https://www.sql-practice.online/interview/topic/sql-basics 2025-08-29T15:02:08.036Z weekly 0.8 https://www.sql-practice.online/interview/topic/stored-procedures 2025-08-14T10:39:46.080Z weekly 0.8 https://www.sql-practice.online/interview/topic/subqueries 2025-06-28T19:33:51.267Z weekly 0.8 https://www.sql-practice.online/interview/topic/transactions 2026-02-04T01:07:38.468Z weekly 0.8 https://www.sql-practice.online/interview/topic/triggers 2024-01-13T11:08:07.520Z weekly 0.8 https://www.sql-practice.online/interview/topic/window-functions 2025-08-21T23:03:24.526Z weekly 0.8