0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select
format(min(v.creationdate),'yyyy-MM-dd') as [First Registered],
case when vt.name is not null then vt.name else v.votetypeid end as [Vote Type]
from
votes as v
left join votetypes as vt on vt.id = v.votetypeid
where
v.votetypeid in (19,20,21,29,30,31,32,33)
group by
v.votetypeid,
vt.id,
vt.name
order by
min(v.creationdate) asc

fork query

edited aug 14 anonymous

created aug 14 0Valt