Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

SELECT Student.name, Student.SIDFROM Student, LevelWHERE Student.SID = Level.SIDAND Level.Level = "freshman"AND Student.Course = 3;
  • Interview Candidate
  • 0
  • 1328

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions