IBM Interview Question

Write a query to extract username from the email column.