Ready to get started with anonymous questions today? It's easy! Learn more.
SELECT Account, count(*) as ct FROM Table1 where version like 'x.0.0' and Account != '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account having count(*) >= 5 order by ct desc; select Account, count(*) as ct_dev from Table1 t1 left outer join Table2 t2 on t1.tr = t2.DevTr where DevTr is not null and account is not null and account <> '' and DATEDIFF(day, ReceivedDate,GETDATE()) < 30 group by Account order by ct_dev desc;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.