Cvent interview question

basic order of sql execution , joins