select s.name, c.SID from Student s, level c where s.sid = c.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 / dharmendra singh

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

Answer Posted / dharmendra singh

select s.name,
c.SID
from Student s, level c
where s.sid = c.sid
and s.course = 3
and l.level = 'freshman';

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I add a database to sql?

1139

What is structural independence and why is it important?

1042

What are different types of sql commands?

1130

What is sql server and ase?

1037

What is difference between sql and mysql?

1140

what is online transaction processing (oltp)? : Sql dba

1004

What is dcl in sql?

968

What are records give examples?

1018

How do you create a unique index?

1053

What is difference between hql and sql?

1090

How are functions and procedures called in PL/SQL?

1249

Why do we use subquery?

1027

Can we delete column in sql?

1113

What are all different types of collation sensitivity?

1044

What is sql dialect?

1127