Interview Guides

Upgrade

Audit CRM Data Integrity by Team | Dataford Interview Questions - Dataford - Ace your Interview

All questions/SQL & Data Manipulation/Audit CRM Data Integrity by Team

Audit CRM Data Integrity by Team

Medium

SQL & Data Manipulation

Asked at 1 company1JoinsData WranglingQuality

Asked 1w ago|AlphaSense

Also asked at

Problem

You are given CRM records entered by multiple teams. Write a PostgreSQL query that returns each team’s total records, the number of records with data integrity issues, and the issue rate. Treat a record as problematic if it has a missing owner, a missing account, or a status that is not one of new, working, qualified, or closed.