List customer_id, name and email of customers whose email ends with @mail.com and whose name contains the letter 'y' in any case.
6 rows with columns customer_id, name, email — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 2 | Diya Patel | diya@mail.com |
| 2 | 6 | Ananya Rao | ananya@mail.com |
| 3 | 8 | Saanvi Iyer | saanvi@mail.com |
Run your code to see the output here.