0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

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,29,30,31,32,33)
group by
v.votetypeid,
vt.id,
vt.name
order by
min(v.creationdate) asc

fork query

edited aug 14

created aug 14 0Valt