13 Replies Latest reply: Apr 12, 2017 12:35 PM by Vineeth Pujari RSS

    Applying Not In for multiple Tables

    Supriya R

      Hi,

       

      i have 3 tables

       

      Table1:   

      UserIDCourseCompletedADClicked
      3411
      4310
      4511
      4600
      4700
      4810

      //above table contains  CourseCompleted and Not CourseCompleted Users

      Table2:   

      DownloadIDUserIDdownloaded
      23340
      24430
      25452
      28483

      //above table contains only CourseCompleted Users


      Table3:

      UserIDtypeID
      347
      4323
      4523
      4623
      4723
      486
      455
      464
      4823

      //above table contains  CourseCompleted and Not CourseCompleted Users

       

      Here i Need to get below Counts:

      1.) Count of ADClicked by CourseCompleted users only.

      2.) Count of downloaded by CourseCompleted users only.

      3.) Count of CourseCompleted users only who has typeID = 23.

      4.) Count of CourseCompleted users who has not involved in any of above actions .