Tag: revenue

SQL: How to return revenue for specific year

I would like to show the revenue for a specific year for all customers regardless of whether or not they have revenue data for the specific year. (in cases they dont have data for the specific year, a filler like ‘no data’ would work) Sample Data looks like: Table 1 Customer Price Quantity Order Date xxx 12 5 1990/03/25 yyy

Calculate total revenue made from each item broken down by country and day

mysql revenue sql

I have a table which consists: id country Date item_name price ae3u2 USA 27/12/2018 budget 1.99 bf5d8 India 31/12/2018 everything 34.99 dc8a4 USA 22/01/2019 cars …