Referencing Aliased Columns

Hi there,

I'm trying to calculate a sort of rating:

select Player,
sum(case when Event = 'S' then 1.0 else 0.0 end) as Success,
sum(case when Event in ('S', 'F') then 1.0 else 0.0 end) as Attempts,
case when Attempts > 0 then Success / Attempts else NULL end as Rating
from EventList
group by Player

It says comlumn names are invalid. Any idea?

Thanks,
Bjoern


The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.