Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Your objective is to write a query that retrieves each username along with the last 4 digits of their Social Security Number (SSN) only for zip codes starting with the number 1. To answer this question, you will be using the users table:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | The full name of the user |
| zip_code | The user's zip code |
| ssn_number | The user's Social Security Number |
Your objective is to write a query that retrieves each username along with the last 4 digits of their Social Security Number (SSN) only for zip codes starting with the number 1. To answer this question, you will be using the users table:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | The full name of the user |
| zip_code | The user's zip code |
| ssn_number | The user's Social Security Number |
| name | last_4_digits |
|---|---|
| Alice Johnson | 6789 |
| Bob Smith | 7890 |
| Charlie Brown | 8901 |
| name | last_4_digits |
|---|---|
| Alice Johnson | 6789 |
| Bob Smith | 7890 |
| Charlie Brown | 8901 |