Return email and username — the part before the @ — for employees with an email.
19 rows with columns email, username — first 3 shown:
| # | ||
|---|---|---|
| 1 | anita.sharma@company.in | anita.sharma |
| 2 | rahul.verma@company.in | rahul.verma |
| 3 | priya.nair@company.in | priya.nair |
Run your code to see the output here.