Test #2

Activity

1. pratik221b commented on Jul 15, 2023

   

   pratik221b

   on Jul 15, 2023

   More actions

   Is this correct?

   SELECT TRANSACTION_COUNT, COUNT(VISIT_DATE) AS VISITS_COUNT
   FROM
   (

   SELECT A.USER_ID, A.VISIT_DATE, SUM( CASE WHEN B.TRANSACTION_DATE IS NULL THEN 0 ELSE 1 ) AS TRANSACTIONS_COUNT
   FROM VISITS A LEFT JOIN TRANSACTIONS B ON A.USER_ID=B.USER_ID AND A.VISIT_DATE=B.TRANSACTION_DATE
   GROUP BY 1,2
   

   )
   GROUP BY 1