Join then Filter Retail - SQL for Data Analysis

An INNER JOIN can add customer fields first, then WHERE filters the joined rows to one customer segment.

highlighted = computed this step

Orders input

Start with orders that carry customer keys.

\text{Orders}

Customers maps matching customer keys to segments.

\text{Customers}

INNER JOIN adds customer segment for matching keys, then WHERE keeps retail rows.

\text{JOIN then WHERE segment = retail}

Only the joined retail order remains.

\text{retail joined rows}