Show all the sections whose enrollment is greater than 5. Display course and section number. Do two versions – one using a join and the other with a correlated subquery. (10 rows)
What will be an ideal response?
```
SELECT s.course_no, s.section_no
FROM section s
WHERE 5 < (SELECT COUNT(*)
FROM enrollment e
WHERE e.section_id = s.section_id)
```
```
SELECT course_no, section_no,
COUNT(student_id)
FROM section, enrollment
WHERE section.section_id = enrollment.section_id
GROUP BY course_no, section_no
HAVING COUNT(student_id) > 5
```
You might also like to view...
A ____ is any Outlook item such as a task, an email message, or a contact that has been flagged for follow-up later.
A. task cluster B. to-do list C. to-do item D. category
Answer the following statements true (T) or false (F)
1. Ajax involves the use of JavaScript and hidden fields for sending client data to the server. 2. Ajax allows Web developers to build a Web page that works more like a traditional desktop program. 3. With Ajax, as new data is needed, the browser sends a request to the server, and the server sends a small amount of data back to the browser, which updates the current page. 4. A tab dialogue box should have two buttons: OK and Cancel.
The Linux file system is similar to Windows.
Answer the following statement true (T) or false (F)
Match the following terms to their meanings:
I. Trendline II. Linear trendline III. Exponential trendline IV. Linear forecast trendline V. Moving average trendline A. Where data points create a symmetric arc B. Graphic representation of trends in a data series C. Where data points follow a smooth curve to show data fluctuations D. Where data points follow a straight line with a two-period forecast E. Where data points follow a straight line