Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT
  2. model_number,
  3. title,
  4. SUM(unit_cost_cents / 100.00 * quantity_ordered) as total
  5. FROM orders
  6. GROUP BY model_number
  7. HAVING SUM(quantity_submitted) > 0
  8. ORDER BY total DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement