I'm trying to manipulate data a little by using a case statement but can't seem to figure it out.
Stops
--------------------
1Stop
1-Stop
1 stop
1 Stop
1stop
1 Stop
2-Stop
Im trying to come up with:
1-Stop.... 6
2-Stop.... 1
What I've tried is:
select CASE when
Stops = '1Stop' OR
Stops = '1 Stop' OR
Stops = '1 stop' then '1-Stop'
ELSE Stops END, count(*)
from table group by Stops