select s.name,s.sid from student s,level l where s.sid=l.sid and s.course

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 / smriti

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

Answer Posted / smriti

select s.name,s.sid from student s,level l
where s.sid=l.sid
and s.course=3
and l.level='freshman'

Is This Answer Correct ?

21 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I use google cloud in sql?

1026

Can a procedure in a package be overloaded?

981

What are %type and %rowtype for?

1009

Is sql microsoft?

975

Is sql open source?

914

What is a unique key?

997

How to use sql statements in pl/sql?

1050

What is dense_rank in sql?

915

What is data manipulation language?

1134

What is sql engine in oracle?

924

Explain the savepoint statement.

1037

Is sqlexception checked or unchecked?

917

What are the different set operators available in sql?

970

how to increment dates by 1 in mysql? : Sql dba

924

What is sqlite used for?

933