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.
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
Where is pl sql used?
What is data profiling in sql?
What does the file extension accdb stand for?
How do you declare a variable in pl sql?
explain primary keys and auto increment fields in mysql : sql dba
what is 'mysqlcheck'? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
how to show all tables with 'mysql'? : Sql dba
What is your daily office routine?
What is data modelling in sql?
How many sql are there?
how to use regular expression in pattern match conditions? : Sql dba
Can a commit statement be executed as part of a trigger?
Where is sql database stored?
How to use transactions efficiently : transact sql