Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1.  
  2.  
  3.  
  4.  
  5. SELECT customer.first_name, customer.last_name, o.quantity
  6. FROM customer
  7. INNER JOIN
  8. (
  9. SELECT cust_id
  10. COUNT(*) AS quantity
  11. FROM cust_order
  12. GROUP BY cust_id
  13. )
  14. AS o
  15. ON customer.cust_id = o.cust_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement