1. Write a query in SQL that returns a count of students who have taken courses offered by CSE department each semester. Include course number, course name, semester taken and number of students who have taken the course in that semester.   

STUDENT Name Student_number Class Major Smith 17 1 CS Brown 8 2 CS COURSE Course name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION GRADE_REPORT Course number Credit hours Department Student number Section identifier Grade CS1310 4 CS 17 112 B CS3320 4 CS 17 119 C MATH2410 CS3380 3 MATH 8 85 A 3 CS 8 92 A 8 102 B 8 135 A Section identifier Course_numriber Semester Year Instructor 85 MATH2110 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang PREREQUISITE Course_number CS3380 CS3380 119 CS1310 Fall 08 Anderson CS3320 135 CS3380 Fall 08 Stone Prerequisite number CS3320 MATH2410 CS1310