Normalize Email Addresses

Problem

User-submitted email addresses sometimes arrive with inconsistent casing. Before sending a batch email campaign, a company might normalize every address to lowercase so that deduplication and lookups behave consistently. Using the users table, return id, name, and email_normalized — the email address converted to all lowercase. Sort results by id.

Schema

users

Sample Data

Expected Output

Explanation

LOWER() converts every character in the email to lowercase. Emails already in lowercase are unchanged.