Guest User

Untitled

a guest
Jan 17th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT nameCustomer AS customer_name, (
  2. SELECT idItem
  3. FROM detailSale
  4. INNER JOIN sales on sales.idDetail = detailSale.idDetail
  5. WHERE sales.idCustomer = cliente.idCustomer
  6. GROUP BY idItem
  7. ORDER BY SUM(amountBuyItem) DESC
  8. LIMIT 1
  9. )
  10. FROM cliente
  11.  
  12. SELECT idCustomer, idItem, SUM(amountBuyItem) AS totalBuyItem
  13. FROM detailSale
  14. INNER JOIN sales on sales.idDetail = detailSale.idDetail
  15. GROUP BY idCustomer, idItem
  16. ORDER BY idCustomer, idItem DESC
Add Comment
Please, Sign In to add comment