Standardizing Text Case

The Problem

Same data entered differently:

• "SALES", "sales", "Sales" → should be one value

  The Solution

  - UPPER(column) - converts to uppercase

• LOWER(column) - converts to lowercase

  Your Task

  Standardize the source column for analysis:

• Show original source

• Standardized source (lowercase, trimmed)

• Count of leads per standardized source

  Group by the standardized value.

Order by count descending.