MFC Tokens

Individual tips and going pvt is my major tipping activity. I should save more tokens for pvt…

select type, sum(amount) from mfc group by type order by sum(amount) desc;

select * from mfc order by amount desc limit 20;

Total tokens given to the person. Also, *0.08 shows how much USD I spent. * 0.05 is how much USD the person got.

SELECT 
  PERSON, SUM(AMOUNT), 
  SUM(AMOUNT)*0.08 AS "USD SPENT", 
  SUM(AMOUNT)*0.05 AS "USD RECEIVED", 
  MIN(DATE(DTLOCAL)), 
  MAX(DATE(DTLOCAL))
FROM mfc GROUP BY PERSON ORDER BY SUM(AMOUNT) DESC;

Sum of all token activity per month.

SELECT
  date_format(dtlocal,"%Y-%m") as "YYYY-MM", sum(amount)
from mfc
group by date_format(dtlocal,"%Y-%m")
order by date_format(dtlocal,"%Y-%m") desc;

How many times have I given the person some tokens.

select 
  person, count(*) as "Total Tips", 
  sum(amount) as "Total Amount Tipped"
from mfc
group by person
order by count(*) desc
limit 10;