Trying to use forms linked to sheets to create a roster

Hello hello!

So I help with a club. We are holding what we call a census just to keep track of everyone. We plan on doing this in google forms. We are collecting
Name, user name, role (student, member, partner). If they are a student, we need their email and if they are a partner, we need the name of who "hosts them"

after getting the form, we want to have a connected google sheets to better see all of this information. I'd love a tab for everyone (we hope to update this yearly though new members will be filling it out as they join throughout the year), and a tab for just students, but i am not understanding how the QUERY function works. It seems the query function gives me just all of the responses, I am unsure how to get it to be "student specific" etc.