gistfile1.sql

select 
  sum(aggregated_data._getSource(source, source2, source3, fb_source, request_ids)='no_source')
FROM 
  g9_tracker.app_logins u 
WHERE 
  u.created_date = '2014-04-22';

select sum(IF(source IS NOT NULL AND 
         source2 IS NOT NULL AND 
         source3 IS NOT NULL AND 
         fb_source IS NOT NULL AND 
         request_ids IS NOT NULL, 'request_id', 'no_source')='no_source')
FROM 
  g9_tracker.app_logins u 
WHERE 
  u.created_date = '2014-04-22';