select v.* from virtual_assistants.virtual_assistants v , virtual_assistants.choice_subcategories cs where
         v.id=cs.virtual_assistant_id    GROUP BY
        v.name order by v.name