1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT COUNT(Id), convert(date, CreationDate)
FROM Users
WHERE convert(date, CreationDate) >= convert(date, ##Start:string##) AND convert(date, CreationDate) <= convert(date, ##End:string##) AND upper(DisplayName) Like '%GOOGLE%'
GROUP BY convert(date, CreationDate)
ORDER BY convert(date, CreationDate)

fork query

edited jul 18 20 Alice CHING

created jun 16 20 anonymous