University of Toledo

5. Explain the functionality of the following query. SELECT section_id, capacity, CASE WHEN MOD (capacity, 2) 0 THEN 'Odd capacity' ELSE 'Even capacity' END "Odd or Even" FROM section. WHERE section_id IN (101, 146, 147) Solution: The query shows for sections 101, 146, and 147 the SECTION_ID and CAPACITY in the first two columns. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download