select stud.name NAME, stud.sid SID from student stud, level

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 / debanjan rudra

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

Answer Posted / debanjan rudra

select stud.name NAME,
stud.sid SID
from student stud,
level lvl
where stud.course = 3
and lvl.level = 'freshman';

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between left join and right join?

930

What is difference between cursor and trigger?

1056

Can we call dml statement in function?

1027

What is the difference between function, procedure and package in pl/sql?

1224

What is use of package in pl sql?

995

explain what is mysql? : Sql dba

1065

what is sql profiler? : Sql dba

1024

what is transaction? : Sql dba

992

Is mariadb a nosql database?

1036

What is sql and explain its components?

1044

What is db journal file?

1035

what are date and time intervals? : Sql dba

1035

How to make a copy values from one column to another in sql?

1022

What is a database trigger?

1050

What is %rowtype in pl sql?

975