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
```
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
The Query Wizard uses a(n) ________ dialog box to create a query
Fill in the blank(s) with correct word