Q&A about the site for active researchers, academics and students of physics
-- Enter Query Title -- Enter Query Description --Select MONTH(CreationDate) MONTH, Count(CreationDate) count_records from Users where YEAR (CreationDate) >= '2010' GROUP BY MONTH (CreationDate) q2 --select count(*) users from users Q1 --select * from users where location = 'South Africa' order by reputation desc --select * from badges where UserId =6282 and name = 'Enlightened' --select * from Posts where PostTypeId =1 and ownerUserId =6282 Q3 select * from users where displayname='Adriaan Stander'