What is Linda Smith's Major?
select major from student where fname = "Linda" and lname = "Smith";
How about Linda Smith's Adivisor?
select advisor from student where fname = "Linda" and lname = "Smith";
Give her gender.
select sex from student where fname = "Linda" and lname = "Smith";