Group by single column

select f.*, 
       count(*) over (
         partition by title, uk_release_date
       ) ct
from   films f;

select * 
from   (
  select f.*, 
         count(*) over (
           partition by title, uk_release_date
         ) ct
  from   films f
)
where  ct > 1

Or you could use the with clause:

with film_counts as (
  select f.*, count(*) over (partition by title, uk_release_date) ct
  from   films f
)
  select *
  from   film_counts
  where  ct > 1