Show the number of enrollments for all sections of course number 122. (5 rows)

What will be an ideal response?


```
SELECT s.section_no, s.course_no, COUNT (*) Count
FROM section s, enrollment e
WHERE e.section_id = s.section_id
AND s.course_no = 122
GROUP BY s.course_no, s.section_no
```

Computer Science & Information Technology

You might also like to view...

A default constructor has how many parameters?

a. 0. b. 1. c. 2. d. Variable number.

Computer Science & Information Technology

Which statement is false?

a. A linked list is a linear collection of self-referential class objects called nodes connected by reference links. b. A linked list is appropriate when the number of data elements to be represented in the data structure is unpredictable. c. A linked list is a fixed-size data structure. d. By convention, the link reference in the last node of a list is set to null to mark the end of the list.

Computer Science & Information Technology

The ________ is responsible for the Internet's domain name system and the allocation of IP addresses

A) IAB B) W3C C) ICANN D) ISOC

Computer Science & Information Technology

All of the following factors affect equipment room design and selection EXCEPT:

A. location B. size C. power D. operating system

Computer Science & Information Technology