工作中常用的SQL

SELECT a.id, sum(a.tingdou_amount) 挺豆余额, sum(a.tbi_amount) T币余额, sum(a.tdian_amount) T点余额 FROM
         (SELECT userid as id, 
                   avail_amount as tingdou_amount,
                   0 as tbi_amount,
                   0 as tdian_amount
                   FROM db_wlt_gameplatform.game_user_account
                   WHERE userid in (123)
         UNION ALL
         SELECT
                   user_id as id, 
                   0 as tingdou_amount,
                   available_coin/500 as tbi_amount,
                   0 as tdian_amount
                   from db_wlt_gameplatform.game_customize_user_account
                   WHERE user_id in (123)
         UNION ALL
         SELECT 
                   u.id as id,
                   0 as tingdou_amount,
                   0 as tbi_amount,
                   SUM( t.points )/500 as tdian_amount
                   FROM db_wlt_gamepoint.points_user_total t
                   INNER JOIN db_wlt_gameplatform.game_user u ON t.passport_id = u.passport_id
                   WHERE u.id in (123)
                   AND (t.overdue_date > NOW( ) OR overdue_date =  '0000-00-00 00:00:00')
                   AND t.delete_flag =0
                   GROUP BY u.id)
AS a
group by a.id