79671796

Date: 2025-06-19 09:00:40
Score: 2.5
Natty:
Report link

A correlated subquery will act as a GROUP BY:

select count(Name) occurrences, count(distinct Name) names
from DuplicateData d
where (select count(*) from DuplicateData dd where dd.Name = d.Name) > 1; -- Only count duplicates.
occurrences names
6 2

… But why????

Reasons:
  • Blacklisted phrase (1): ???
  • Blacklisted phrase (0.5): why?
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • High reputation (-1):
Posted by: Guillaume Outters