SQL Practice Logo

SQLPractice Online

String Functions & Operations: Real-World

Module: SQL Fundamentals

A customer database stores names like " John Doe " (extra spaces), emails in mixed case "John.Doe@Gmail.Com", and phone numbers "555-123-4567". You need to: normalize names, search by email domain, extract area codes, and clean messy user input without breaking database performance.

Scenario

Problem

Benefit

Solution

SELECT 1;

All