SELECT S.Name ,S.SID FROM Student S INNER JOIN Level L ON S.SID=L

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

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

Answer Posted / ani

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is nvl?

1071

How can a pl sql block be executed?

950

What is transaction control language (tcl)?

1145

What are tables and fields in the database?

1122

Explain what is a database?

1091

In a distributed database system, can we execute two queries simultaneously?

1100

What is the least restrictive isolation level? : Transact sql

1079

What are two statement types in sql?

1119

What is a null value?

1151

Why is normalization important?

1038

How much does sql certification cost?

1097

how to check server status with 'mysqladmin'? : Sql dba

1086

Can you join a table to itself?

1144

Which tcp/ip port does sql server run?

1017

Write a sql query to find the names of employees that begin with ‘a’?

1021