select

count(distinct SIGNER_ID) as devs,

count(*) as commits,

commits/devs as "Commit per devs",

count(distinct widget_name) as widgets,

commits/widgets as "Commit per widget"

from near.social.fact_widget_deployments