PayPal SELECT SUM(Gross / 26)

SELECT SUM(Gross / 26) AS TotalNet FROM paypal_2022 where Date like '%2022-08%' and Item_Title like '%example%'

Note: The Date column in this example was not changed in the table, so MySQL is set to type DATE. This will throw a warning, but will still show the right number. To remove the warning, simply change DATE to some other type, for example, VARCHAR.

Paddle
SELECT Product_Name, COUNT(Product_Name) as count FROM paddle_2022
GROUP BY Product_Name
ORDER BY count DESC

Leave a Reply

Your email address will not be published.

Shares