Total revenue by product category
SQL query for Mews
Get the total revenue for each product category.
SELECT pc.name, SUM(oi.price) AS total_revenue FROM productcategories pc JOIN products p ON pc.id = p.categoryid JOIN orderitems oi ON p.id = oi.productid GROUP BY pc.name
Mews data model
Accountingcategories
Accountingitems
Accountnotes
Addresses
Agecategories
Availabilityblocks
Availabilityadjustments
Bills
Businesssegments
Cashiers
Cashiertransactions
Commands
Companies
Companionships
Companycontracts
Configuration
Counters
Countries
Creditcards
Currencies
Customers
Departments
Devices
Exchangerates
Languages
Loyaltymemberships
Loyaltyprograms
Loyaltytiers
Messagethreads
Orderitems
Outletitems
Outlets
Payments
Paymentrequests
Products
Productcategories
Productserviceorders
Rates
Rategroups
Reservations
Reservationgroups
Resourceaccesstokens
Resourceblocks
Resources
Resourcecategories
Resourcecategoryassignments
Resourcefeatures
Restrictions
Rules
Routing Rules
Services
Sources
Sourceassignments
Serviceoverbookinglimits
Tasks
Taxenvironments
Taxation
Vouchers
Vouchercodes
Voucherassignments
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed