API信息

select COUNT(user_id) AS'api人数',sum(margin_balance )AS'保证金总金额'
FROM(
SELECT DISTINCT A.user_id,c.margin_balance/100000000 as 'margin_balance' from  t_api_key A
LEFT JOIN clear.t_account as c
ON c.client_id=A.user_id
where key_type=2
)B