SELECT Student.name, Student.SID FROM Student, Level WHERE Student.SID =

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.

Question Posted / supreeth

9 Answers
16133 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / supreeth

SELECT Student.name, Student.SID
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is not null in sql?

1104

Can sql function call stored procedure?

1069

Is id a reserved word in sql?

1183

What are the advantages of sql? Explain

1147

How many databases can sql express handle?

1026

Which is better cte or subquery?

1074

Why do we use sqlite?

1025

What is a sql driver?

1032

What does t sql mean?

997

Why is theta join required?

1185

How do I create an index in word?

1072

Can we use delete in merge statement?

1096

How to add a column ‘salary’ to a table employee_details?

1052

How do you clear the screen in sql?

1120

What is set serveroutput on?

1175