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

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares