Group by and Having

[Progsenya]

select sum(s.cnt)*f.Price,f.Name
from Films f inner join [Sessions] s
on f.FilmsID=s.FilmsID

group by f.Name
having sum(s.cnt)*f.Price>1000
вот такой вот код смысл в том чтобы вывести все записи сумма которых больше 1000


вот такая ошибка кто поможет буду благолдарен

Msg 8121, Level 16, State 1, Line 34
Column 'Films.Price' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.

[Аватар]

А если так:

SELECT U.*
  FROM (
    select sum(s.cnt)*f.Price AS kk,f.Name
      from Films f
        inner join [Sessions] s on f.FilmsID=s.FilmsID
      group by f.Name) AS U
  WHERE U.kk>1000

наверно правильней

SELECT U.*
  FROM (
    select sum(s.cnt*f.Price) AS kk,f.Name
      from Films f
        inner join [Sessions] s on f.FilmsID=s.FilmsID
      group by f.Name) AS U
  WHERE U.kk>1000