count subquery sql
/*count sub query
Depends on the use case, here are a few options*/
Select Count(*) from
(
--Sub query
Select id from users
) as userCount
Select * from
(
--Sub query
select count(id) as cnt from Users where LastPasswordChangedDate < '2021-01-01'
) as LastPasswordChangedDate
Select
(
--Sub query
select count(id) as cnt from Users where LastPasswordChangedDate < '2021-01-01'
) as LastPasswordChangedDateCount
, *
from Users
where LastPasswordChangedDate < '2021-01-01'