Interview Guides

Interview Guides

All questions/SQL & Data Manipulation/Investigate Reporting Count Discrepancies

Investigate Reporting Count Discrepancies

Medium

SQL & Data Manipulation

Asked at 1 company1JoinsAggregationsData Wrangling

Also asked at

A

Problem

Compare Alabama Staffing reporting snapshot counts against database-derived confirmed placement counts by client and day for January 2024. Return both totals, the discrepancy, and a status that highlights matches, mismatches, and rows missing from one side.

Schema

Tables

clients
placements
reporting_snapshots

What This Tests

Joining aggregated reporting data to source-of-truth data
Using CTEs to separate metric definitions
Handling NULLs and missing rows correctly
Classifying discrepancies with CASE

Problem

Compare Alabama Staffing reporting snapshot counts against database-derived confirmed placement counts by client and day for January 2024. Return both totals, the discrepancy, and a status that highlights matches, mismatches, and rows missing from one side.

Schema

Tables

clients
placements
reporting_snapshots

What This Tests

Joining aggregated reporting data to source-of-truth data
Using CTEs to separate metric definitions
Handling NULLs and missing rows correctly
Classifying discrepancies with CASE

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Investigate Reporting Count Discrepancies | Dataford Interview Questions - Dataford - Ace your Interview