Every email starts with a username: the part before the @, such as aisha.verma. For
each customer, show customer_id, the username as username, and a display name made from the
username as display_name: the dot replaced by a space, and every word starting with a capital
letter, so aisha.verma becomes Aisha Verma.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
Every email starts with a username: the part before the @, such as aisha.verma. For
each customer, show customer_id, the username as username, and a display name made from the
username as display_name: the dot replaced by a space, and every word starting with a capital
letter, so aisha.verma becomes Aisha Verma.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| customer_id | username | display_name |
|---|---|---|
| 1 | aisha.verma | Aisha Verma |
| 2 | rahul.sharma | Rahul Sharma |
| 3 | sneha.patel | Sneha Patel |
| 4 | amit.kumar | Amit Kumar |
| 5 | pooja.singh | Pooja Singh |
| 6 | vikash.yadav | Vikash Yadav |
| 7 | neha.gupta | Neha Gupta |
| 8 | rajesh.khanna | Rajesh Khanna |
| 9 | kavita.rao | Kavita Rao |
| 10 | sanjay.mehta | Sanjay Mehta |
| 11 | anita.desai | Anita Desai |
| 12 | ravi.nair | Ravi Nair |
| 13 | meena.iyer | Meena Iyer |
| 14 | arun.joshi | Arun Joshi |
| 15 | divya.menon | Divya Menon |
| 16 | karan.malhotra | Karan Malhotra |
| 17 | pallavi.kulkarni | Pallavi Kulkarni |
| 18 | nikhil.bose | Nikhil Bose |
| 19 | shreya.reddy | Shreya Reddy |
| 20 | manoj.tiwari2 | Manoj Tiwari2 |
| 21 | fatima.khan | Fatima Khan |
| 22 | george.thomas | George Thomas |
| 23 | lakshmi.venkat | Lakshmi Venkat |
| 24 | imran.sheikh | Imran Sheikh |
| 25 | sara.dsouza | Sara Dsouza |
| 26 | rohan.das | Rohan Das |
| 27 | priya.bhatt | Priya Bhatt |
| 28 | harish.pillai | Harish Pillai |
| 29 | zoya.ahmed | Zoya Ahmed |
Run query to see output