Bitstamp to Coins.ph summary by tag

SELECT
  DestinationTag,
  COUNT(Destination) AS TxCount,
  SUM(CAST(AmountXRP AS NUMERIC)) / 1000000 AS TotalXRP, -- Convert total drops to XRP, without scientific notation output.
  MIN(EXTRACT(DATE FROM l.CloseTime)) AS FirstTransactionDate,
  MAX(EXTRACT(DATE FROM l.CloseTime)) AS LastTransactionDate
FROM
  xrpledgerdata.fullhistory.transactions t
JOIN
  xrpledgerdata.fullhistory.ledgers l
ON
  t.LedgerIndex = l.LedgerIndex
WHERE
  Account = 'rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv'
  AND
  AmountXRP IS NOT NULL
  AND
  TransactionType = 'Payment'
  AND
  Destination = 'rU2mEJSLqBRkYLVTv55rFTgQajkLTnT6mA'
  AND
  TransactionResult = 'tesSUCCESS'
GROUP BY
  DestinationTag
ORDER BY
  COUNT(Destination) DESC