SELECT DISTINCT sname, COUNT(verdict) AS verdict FROM ( SELECT * FROM submission where verdict='Accepted' and sname='shawon' GROUP BY pbname, sname)T1 GROUP BY sname;
[MySQL] Online Judge User's Unique Total Solved Problem Query
SELECT DISTINCT sname, COUNT(verdict) AS verdict FROM ( SELECT * FROM submission where verdict='Accepted' and sname='shawon' GROUP BY pbname, sname)T1 GROUP BY sname;
0 comments:
Post a Comment