Stream Txt blue hour!!!&$&$&$&&
Answer:
Check the explanation
Explanation:
Q1: SQL to list names of all the students whose GPA is above specific number:
select SName
from Student
where GPA >= 3.8;
Using the Student table we are able to get the details where the GPa is greater than the required value.
Q2: SQL to get list of names of all the students who applied to some college:
select SName from Student where SID in (
select distinct SID from Apply
);
Selecting the name of the students who are present in the Apply table.
Q3: SQL to get list of names all the students who did not apply to any college:
select SName from Student where SID not in (
select distinct SID from Apply
);
Selecting the name of the students who are not present in the Apply table.
Q4: SQL to get list of names and enrollment of all the colleges who received applications for a major involving bio:
select CName, Enrollment from College where CName in (
select CName from Apply where Major = 'Bio' and SID in (
select SID from Student
)
);
