Create a list of courses, sections and their capacity. Produce the result in the following format: (78 rows)

Course and Section CAPACITY
-------------------- ---------- ----------------------------------------
350 Section 3 ---------- 25
10 Section 2 ---------- 15
20 Section 2 ---------- 15



```
SELECT LPAD(course_no||' Section '||section_no, 20)
"Course and Section",
RPAD('-',10,'-') " ",LTRIM(capacity) Capacity
FROM section
```

Computer Science & Information Technology

You might also like to view...

A(n) ________ tab will align the middle of the text under the tab

Fill in the blank(s) with correct word

Computer Science & Information Technology

The Query Wizard uses a(n) ________ dialog box to create a query

Fill in the blank(s) with correct word

Computer Science & Information Technology