Q&A for scientists using computers to solve scientific problems
WITH dates(date, score) as ( SELECT DISTINCT CONVERT(DATE, CreationDate) AS date, Score as score FROM Posts WHERE OwnerUserId = ##UserId## ) select * from dates