SELECT S.Name,S.SID FROM Student S, Level L WHERE S.SID=L.SID A

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

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

Answer Posted / guest

SELECT S.Name,S.SID
FROM Student S, Level L
WHERE S.SID=L.SID
AND L.level='freshman'
AND S.Course=3

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the purpose of %type and %rowtype data types?

905

Is mariadb nosql?

1026

what are the advantages a stored procedure? : Sql dba

961

What is normalization sql?

1037

Is oracle sql free?

968

What is database white box testing and black box testing?

1094

What is the difference between sql and isql*plus?

1071

How do I edit a trigger in sql developer?

970

what is text? : Sql dba

1057

What is the main difference between sql and pl/sql?

1070

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1094

Why function is used in sql?

924

Which is faster truncate or drop?

1029

Why we use pl sql?

942

Explian rowid, rownum? What are the psoducolumns we have?

985