我必须计算一列和一个表连接后得到的总和

SELECT 
  fee_amount 
FROM bill 
  INNER JOIN status 
  ON bill_status_id=status_id 

  INNER JOIN user
  ON bill_user_id =user_id 
WHERE  bill_active='Y'

我必须计算这之后返回的费用和金额，我可以使用下面的一个吗？

SELECT 
  SUM(fee_amount) 
FROM (
  SELECT 
    fee_amount 
  FROM bill 
  INNER JOIN status 
  ON bill_status_id=status_id

  INNER JOIN user
  ON bill_user_id =user_id 
  WHERE  bill_active='Y'
)

请建议。