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.
SELECT Product_Name, COUNT(Product_Name) as count FROM paddle_2022
GROUP BY Product_Name
ORDER BY count DESC