Skip to content

Instantly share code, notes, and snippets.

@CristianRP

CristianRP/etl_proyecto.sql

Created June 11, 2019 04:21
Show Gist options
  • Save CristianRP/6077a1953ca8ca108f13fdbdb3536d04 to your computer and use it in GitHub Desktop.
Save CristianRP/6077a1953ca8ca108f13fdbdb3536d04 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
etl_proyecto.sql
SELECT P.ID, P.NAME, COUNT(OD.ID) FORESTACION
FROM PRODUCTS P, ORDER_DETAILS OD
WHERE P.ID = OD.PRODUCT_ID
GROUP BY P.ID, P.NAME
SELECT C.NAME, COUNT(P.ID) FORESTACION FROM CATEGORIES C
INNER JOIN PRODUCTS P ON C.ID = P.CATEGORY_ID
INNER JOIN ORDER_DETAILS OD ON OD.PRODUCT_ID = P.ID
GROUP BY C.NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment