COUNT(DISTINCT TX_ID) AS TX_number,

input_type AS Type,

COUNT(*) AS total_count

(

SELECT

TX_ID,

CASE

WHEN INPUTS [0] :type = 'public'

OR INPUTS [1] :type = 'public'

OR INPUTS [2] :type = 'public'

OR INPUTS [3] :type = 'public'

OR INPUTS [4] :type = 'public' THEN 'public'

WHEN INPUTS [0] :type = 'private'

OR INPUTS [1] :type = 'private'

OR INPUTS [2] :type = 'private' THEN 'private'

END AS input_type

FROM

aleo.core.fact_transitions

WHERE

SUCCEEDED = TRUE

) subq

input_type IS NOT NULL

GROUP BY

input_type