eezhal92 · February 13, 2016 02:58
diff --git a/query.sql b/query.sql
 select c.name, count(u.name) as co from company c 
 join users u on c.id = u.company 
 where datediff(now(), u.join_date) >= 365 
 and u.gender = 'male' group by c.name;
	select c.name, count(u.name) as co from company c
	join users u on c.id = u.company
	where datediff(now(), u.join_date) >= 365
	and u.gender = 'male' group by c.name;