What do you want to know?
Describe the data you need — we’ll turn it into a query.
Results
10 rows
› View SQL
SELECT p.name, p.sku, SUM(op.quantity) as total_sold FROM products p JOIN order_products op ON p.id = op.product_id GROUP BY p.id, p.name, p.sku ORDER BY total_sold DESC LIMIT 10
| Name | Sku | Total Sold |
|---|---|---|
| Dell XPS 13 9340 | LAP-DEL-XPS13-9340 | 82 |
| ASUS TUF VG24VQ | MON-ASU-VG24VQ | 82 |
| Crucial P3 Plus 1TB | CMP-CRU-P3PLUS1TB | 81 |
| iPhone 15 | PHN-APL-IP15 | 80 |
| Ubiquiti UniFi U6 Long-Range AP | NET-UBQ-U6LR | 76 |
| HP Envy x360 14 | LAP-HP-ENVY14 | 75 |
| iPhone 15 Pro | PHN-APL-IP15PRO | 75 |
| LG UltraWide 34WP85C-B | MON-LG-34WP85C | 75 |
| Samsung Galaxy Tab S9 | TAB-SAM-TABS9 | 74 |
| Logitech G733 Lightspeed | AUD-LOG-G733 | 73 |