human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Video_Games (GameID, GName, GType)
Plays_Games (StuID, GameID, Hours_Played)
SportsInfo (StuID, SportName, HoursPerWeek, GamesPlayed, OnScholarship)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the lname of linda
assistant
SELECT LName FROM Student WHERE Fname = 'Linda';
human
what is the age of linda
assistant
SELECT Age FROM Student WHERE Fname = 'Linda';
human
what is the age of kim
assistant
SELECT Age FROM Student WHERE Lname = "Kim" ;