MySQL Count

SELECT COUNT(*), date FROM paypal_2022 where date like ‘%2022-10%’ and type = ‘express checkout payment’ GROUP BY date ORDER BY date

 

==

 

SELECT Item_Title, COUNT(Item_Title) as count FROM paypal_2022 WHERE date like ‘%2022-10%’ and Type = ‘express checkout payment’
GROUP BY Item_Title
ORDER BY count DESC

==

SELECT Item_Title, COUNT(Item_Title) as count FROM paypal_2022 WHERE date like ‘%2022-09%’ and From_Email_Address !=’example@example.com’
GROUP BY Item_Title
ORDER BY count DESC

Paddle Transactions by Month

  1. https://vendors.paddle.com/report/transactions?start_date=2022-01-01&end_date=2022-01-31
  2. https://vendors.paddle.com/report/transactions?start_date=2022-02-01&end_date=2022-02-28
  3. https://vendors.paddle.com/report/transactions?start_date=2022-03-01&end_date=2022-03-31
  4. https://vendors.paddle.com/report/transactions?start_date=2022-04-01&end_date=2022-04-30
  5. https://vendors.paddle.com/report/transactions?start_date=2022-05-01&end_date=2022-05-31
  6. https://vendors.paddle.com/report/transactions?start_date=2022-06-01&end_date=2022-06-30
  7. https://vendors.paddle.com/report/transactions?start_date=2022-07-01&end_date=2022-07-31
  8. https://vendors.paddle.com/report/transactions?start_date=2022-08-01&end_date=2022-08-31
  9. https://vendors.paddle.com/report/transactions?start_date=2022-09-01&end_date=2022-09-30
  10. https://vendors.paddle.com/report/transactions?start_date=2022-10-01&end_date=2022-10-31
  11. https://vendors.paddle.com/report/transactions?start_date=2022-11-01&end_date=2022-11-30
  12. https://vendors.paddle.com/report/transactions?start_date=2022-12-01&end_date=2022-12-31