Find the distinct last names of all the students who have president votes and whose advisor is 8741
select distinct t1.lname from student as t1 join voting_record as t2 on t1.stuid = president_vote intersect select distinct lname from student where advisor = "8741"
first name and the last name please
select lname, fname from student where stuid = "1001"
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"
Can you give me the first and last names for students with Vice President vote 1017
select t1.lname, t1.fname from student as t1 join voting_record as t2 on t1.stuid = t2.stuid where t2.vice_president_vote = "1007"
Give me the age for Linda Smith
select age from student where lname = "Smith" and fname = "Linda"
Give me the names of all the students
select lname, fname from student