Hi All,

I have having a problem conducting an aggregated function off an alias column I create on the fly. I get an error saying SearchType is an invalid column name yet when I remove the Count and Group By commands the query results in a column with the name of SearchType.

SELECT
Count(RFQ_ID), "SearchType "=
CASE
WHEN SVC_COLO = 'Y' THEN 'Colocation'
WHEN SVC_BANDWIDTH...