Extract Username from Email

Problem

When a new user signs up, a product might auto-populate their display name with the local part of their email — the piece before the @. Using the users table, return name and username, where username is everything in the email column before the @ symbol. Sort by name.

Schema

users

Sample Data

Expected Output

Explanation

Everything before the @ is returned as the username. Dots and numbers inside the local part are preserved as-is.