text: select
          count(*)
  from
          j1 INNER JOIN j4 ON
          (
           j1.c_date = j4.c_date
  
          )
  where
          j1.c_date IN (select c_date from j2)
  	--and exists (select c_date from j3 )
  	and cast(j1.c_integer as bigint) <> j4.c_bigint
  ;
  