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
15595 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

Which join is like inner join?

978

Where do we use pl sql?

945

What is the use of partition by in sql?

931

How do I save the results of sql query in a file?

929

How to move files from one directory to another in pl sql?

1130

what is meant by nl2br()? : Sql dba

975

What are the types of keys?

935

what are ddl statements in mysql? : Sql dba

1114

what is the difference difference between procedure and packages

10251

Is nosql relational?

896

how to create a new view in mysql? : Sql dba

895

Explain what is table in a database?

1009

How do you exit in sql?

1064

how to get a list of columns in an existing table? : Sql dba

916

How many unique keys can a table have?

959