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
15874 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 many types of sql are there?

984

What is the difference between pl and sql?

1088

what is top in tsql? : Transact sql

1110

What is pl sql collection?

955

What is auto increment feature in sql?

1116

What is snowflake sql?

1066

What is type and rowtype in pl sql?

1012

What are the events on which a database trigger can be based?

1178

What is full join?

947

How do you delete duplicates in sql query using rowid?

938

Is sqlite free?

961

Which is better cte or subquery?

1025

How many parts of a pl sql block are optional?

1119

Explain what is an index?

1049

What are the two characteristics of a primary key?

967