Oh sorry for the confusion, it would be great if I can see their first and last name.
select fname, lname from student where age > 18 and major ! = 600 and sex = 'F'
Thank you very much! Then could you please show me the male students' first and last name with the same condition? Meaning older than 18 and not majoring in 600.
select fname, lname from student where age > 18 and major ! = 600 and sex = 'M'
yes please, so my question would be about the oldest male student who is not majoring in 600.
select fname, lname from student where major ! = 600 and sex = 'M' order by age desc limit 1
Then could you please let me know what is Ian Thornton's major and advisor code?
select major, advisor from student where lname = "Thornton" and fname = "Ian"
yes please, first and last name would be great.
select fname, lname from student where sex = 'F' and major = 520