Practice Interview Questions
| Question | Status |
|---|---|
You have two tables: all_numbers and confirmed_numbers. The all_numbers table holds a complete list of phone numbers, while the confirmed_numbers table contains only the numbers that have been successfully confirmed. Your task is to write a query to retrieve all phone numbers from the all_numbers table that do not appear in the confirmed_numbers table, indicating they have not yet been confirmed.
all_numbers table:
| Column Name | Description |
|---|---|
| phone_number | Phone number from the list of all numbers |
confirmed_numbers table:
| Column Name | Description |
|---|---|
| phone_number | Phone number that has been confirmed |
You have two tables: all_numbers and confirmed_numbers. The all_numbers table holds a complete list of phone numbers, while the confirmed_numbers table contains only the numbers that have been successfully confirmed. Your task is to write a query to retrieve all phone numbers from the all_numbers table that do not appear in the confirmed_numbers table, indicating they have not yet been confirmed.
all_numbers table:
| Column Name | Description |
|---|---|
| phone_number | Phone number from the list of all numbers |
confirmed_numbers table:
| Column Name | Description |
|---|---|
| phone_number | Phone number that has been confirmed |
| phone_number |
|---|
| 301-766-8523 |
| 291-874-3478 |
| phone_number |
|---|
| 301-766-8523 |
| 291-874-3478 |