can you give me the students with president vote 1004 | What attributes of that student do you want? | first and last names please
SELECT T1.LNAME, T1.FNAME FROM STUDENT AS T1 JOIN VOTING_RECORD AS T2 ON T1.StuID   =   T2.StuID WHERE T2.PRESIDENT_VOTE  =  "1004"
students with president vote 1004 refers to T2.PRESIDENT_VOTE = '1004'; first and last names refer to T1.LNAME, T1.FNAME; joining tables refers to JOIN; matching student IDs across tables refers to T1.StuID = T2.StuID;