Bistamp to Bitso tag 25490962

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 = 'rfEu1Wnr7LxStoFx8DBdzgr8M16FBUbH3K'
  AND
  TransactionResult = 'tesSUCCESS'
  AND
  DestinationTag = 25490962
GROUP BY
  DestinationTag
ORDER BY
  COUNT(Destination) DESC