Course c where cost select avg cost from course group

This preview shows page 1 - 5 out of 10 pages.

COURSE c where COST >( select AVG ( COST ) from COURSE ) group by c . DESCRIPTION , c . COST ;
Q3. For each zip that has at least one instructor, list the total number of instructors in that zipcode. ;
Q4. For each city in the state of CT, list the total number of students live in that city. Display city, state, number of students in descending order. -- AGGREGATION OF FULL RESULT SET select distinct z . ZIP , z . CITY , z . STATE ,( select count (*) from STUDENT ZIP = z . ZIP ) as Students FROM ZIPCODE z INNER JOIN STUDENT s ON s . ZIP = z . ZIP where z . STATE = 'CT' order by Students where ;
Q5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe. MIN , where ) ;

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture