WeCode
Academy
Tutorials
Web Development
Bootstrap
CSS
HTML
JavaScript
jQuery
Node.js
PHP
React
TypeScript
Programming
C
C#
C++
Go
Java
Python
Rust
Data and Databases
NumPy
Pandas
SQL
Tools
Bash
Git
Projects
Project: A Tiny Shell in C
Project: Bank Account System
Project: Library Management System
Project: Portfolio Page
Project: Quiz App in React
Project: Sales Data Analysis
Project: Server Log Analyser
Project: To-Do REST API
Project: URL Shortener
Project: Word Counter in Four Languages
All tutorials ❯
Paths
References
Practice
Try it editor
Quizzes
How To recipes
Tools
Glossary
My Learning
🌙
Dark mode
Home
›
How To
›
SQL
Total revenue per customer
Join orders to products, multiply price by quantity and add it up.
Example
sql
SELECT c.name, SUM(p.price * o.quantity) AS revenue FROM orders o JOIN customers c ON c.id = o.customer_id JOIN products p ON p.id = o.product_id GROUP BY c.id ORDER BY revenue DESC;
Run ❯
Reset
Open in editor »
More SQL recipes
Find duplicate values
Get the top N rows per query
Find rows with no match in another table
Calculate a running total
Pivot values into columns with CASE
WeCodeAcademyWeCodeAcademy