update u
    set isactive = (case when num_actions > total_actions then 1 else 0 end)
    from users u left join
         (select ua.userid, count(*) as num_actions
          from useractions ua
          group by ua.userid
         ) ua
         on ua.userid = u.id cross join
         (select count(*) as total_actions
          from actions a
         ) a;

create table [User]
(
 Id int not null primary key,
 Name varchar(50) not null,
 IsActive bit not null
)
create table [Actions]
(
 Id int not null primary key,
 Name varchar(50) not null
)
GO
create table [UserActions]
(
 UserId int not null,
 ActionId int not null,
 foreign key (UserId) REFERENCES [User](Id),
 foreign key (ActionId) REFERENCES [Actions](Id)
)
GO
insert into [User] values
(1, 'Alice', 1),(2, 'Bob', 1),(3, 'Caroline', 1)
insert into [Actions] values
(1, 'eat'),(2,'drink'),(3,'sleep')
insert into [UserActions] values
(1,1),(1,2),(1,3),
(2,1),(2,2),
(3,1),(3,2),(3,1)
GO
update us
set us.IsActive = 0
from [User] us
join 
(
 select ua.UserId, COUNT(distinct ua.ActionId) as ActionCount
 from [UserActions] ua
 group by ua.UserId
) as uac on uac.UserId = us.Id
where uac.ActionCount < (select count(*) from [Actions])
select * from [User] us

    Id          Name       IsActive
    ----------- ---------- --------
    1           Alice      1
    2           Bob        0
    3           Caroline   0