The support screen hides most of each phone number. For each customer, show:
customer_idcity_code: the first three letters of the city in capitals, such as DEL for Delhimasked_phone: the first 2 digits, then six asterisks, then the last 2 digits, such as
98******01A customer without a phone number must show NULL, not asterisks.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| city |
The support screen hides most of each phone number. For each customer, show:
customer_idcity_code: the first three letters of the city in capitals, such as DEL for Delhimasked_phone: the first 2 digits, then six asterisks, then the last 2 digits, such as
98******01A customer without a phone number must show NULL, not asterisks.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| city |
| customer_id | city_code | masked_phone |
|---|---|---|
| 1 | DEL | 98******01 |
| 2 | MUM | 98******02 |
| 3 | AHM | NULL |
| 4 | PAT | 98******04 |
| 5 | JAI | 98******05 |
| 6 | LUC | 98******06 |
| 7 | BEN | 98******07 |
| 8 | CHE | 98******08 |
| 9 | HYD | NULL |
| 10 | MUM | 98******10 |
| 11 | PUN | 98******11 |
| 12 | KOC | 98******12 |
| 13 | CHE | 98******13 |
| 14 | DEL | 98******14 |
| 15 | BEN | 98******15 |
| 16 | DEL | NULL |
| 17 | PUN | 98******17 |
| 18 | KOL | 98******18 |
| 19 | HYD | 98******19 |
| 20 | VAR | 98******20 |
| 21 | LUC | 98******21 |
| 22 | KOC | 98******22 |
| 23 | CHE | NULL |
| 24 | BHO | 98******24 |
| 25 | GOA | 98******25 |
| 26 | KOL | 98******26 |
| 27 | SUR | NULL |
| 28 | KOC | 98******28 |
| 29 | IND | 98******29 |
Run query to see output