Your question is Find Mismatches Between Tables. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
How would you write a SQL query using joins to compare records between two tables and find mismatches?
Use the provided employee record tables. Return records that are missing from either table or have different values in any compared attribute.
employee_id, source and target values for name, status, hourly rate, and department, plus mismatch_typeemployee_id ascending| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Employee identifier in the source table |
| employee_name | VARCHAR(100) | Employee name |
| employment_status | VARCHAR(20) | Current employment status |
| hourly_rate | NUMERIC(10,2) | Hourly pay rate |
| department | VARCHAR(50) | Employee department |
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Employee identifier in the target table |
| employee_name | VARCHAR(100) | Employee name |
| employment_status | VARCHAR(20) | Current employment status |
| hourly_rate | NUMERIC(10,2) | Hourly pay rate |
| department | VARCHAR(50) | Employee department |