Top Selling Products
SQL query for Teamleader Focus
Retrieve the top 10 best-selling products based on the total quantity sold.
SELECT p.product_name, SUM(ol.quantity) AS total_quantity_sold FROM products p INNER JOIN orderlines ol ON p.product_id = ol.product_id GROUP BY p.product_name ORDER BY total_quantity_sold DESC LIMIT 10;
Teamleader Focus data model
Activity Types
Business Types
Call Outcomes
Calls
Closing Days
Companies
Contacts
Credit Notes
Current User
Custom Field Definitions
Day Off Types
Deal Sources
Deal Phases
Deals
Departments
Events
Expenses
Invoices
Invoice Lines
Lost Reasons
Materials
Meetings
Milestones
Notes Companies
Notes Contacts
Notes Deals
Orders
Payment Terms
Pipelines
Product Categories
Products
Project Groups
Projectsv
Notes Projectsv
Project Lines
Quotations
Quotation Lines
Subscriptions
Tags
Tasksv
Tax Rates
Teams
Tickets
Time Tracking
Units Of Measure
Users
Users Info
Users Get Week Schedule
Users List Days Off
Work Types
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