Zoox Dataset Verification

What would you do to verify a dataset, and can you write out the queries for those checks?

Using the supplied trips and vehicles tables, write PostgreSQL checks that identify common data-quality issues.

Output

1. Return one row per validation check with check_name, issue_count, and status.
2. Include checks for missing values, duplicate references, invalid values, inconsistent timestamps, and unmatched vehicle references.
3. Sort failed checks first, then by check_name.