[sqlite] Selecting total and not used in one query

[Igor Tandetnik]

On 12/12/2015 9:18 AM, Cecil Westerhof wrote:
> But I want something like:
> ?    SELECT
>          (SELECT COUNT(*) FROM proverbs)                        AS Total
>      ,   (SELECT COUNT(*) FROM proverbs WHERE NOT used IS NULL) AS Used
>      ,   (Total - Used)                                         AS Free

select count(*) Total,
            sum(used is not null) Used,
            sum(used is null) Free,
            sum(any_boolean_condition) CountSatisfyingCondition
from proverbs;

-- 
Igor Tandetnik