and SELECT: nested SELECT statement will in SELECT and FROM Subqueries in FROM clause: 7. SELECT A1.Az.A FROM R1. R WHERE condition; Subquery in FROM clause will generate a table: Q1. Students whose scaled GPA changes GPA by more than 1 SELECT sID, sName, GPA, GPA (sizeHS/ 1000) as scaledGPA FROM STUDENT WHERE abs(GPA (sizeHS/1000) - GPA)>1.0; SELECT FROM (SELECT sID, sName, GPA, GPA WHERE abs(G.scaledGPA - GPA)> 1.0 (sizeHS/1000) as scaledGPA FROM STUDENT) G Subquery in SELECT clause will generate a value: Q2. Colleges paired with the highest GPA of their applicants. SELECT DISTINCT College.cName, state, GPA FROM College, Apply, Student WHERE College.cName Apply.cName and Apply.sID Student.sID and GPA >= ALL ( SELECT GPA FROM Student, Apply WHERE Students|D ApplysID and Apply.cName - College.cName); SELECT cName, state, (SELECT distinct GPA FROM Apply, Student WHERE College.cName Apply.cName and ApplyslDStudentsID and GPA >= ALL ( SELECT GPA FROM Student, Apply WHERE StudentsID-ApplysID and Apply.cName-CollegecName)) as GPA from College