[Solved] You want to categorize ages into 'Child' (0-12), 'Teen' (13-19), 'Adult' (20-64), and 'Senior' (65+). Which IF-ELSIF-ELSE block correctly implements this in PL/pgSQL? | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

You want to categorize ages into 'Child' (0-12), 'Teen' (13-19), 'Adult' (20-64), and 'Senior' (65+). Which IF-ELSIF-ELSE block correctly implements this in PL/pgSQL?

AIF age <= 12 THEN RETURN 'Child'; ELSEIF age <= 19 THEN RETURN 'Teen'; ELSEIF age <= 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF;

BIF age < 12 THEN RETURN 'Child'; ELSIF age < 19 THEN RETURN 'Teen'; ELSIF age < 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF;

CIF age <= 12 THEN RETURN 'Child'; ELSIF age <= 19 THEN RETURN 'Teen'; ELSIF age <= 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF;

DIF age < 12 THEN RETURN 'Child'; ELSIF age < 20 THEN RETURN 'Teen'; ELSIF age < 65 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF;

Step-by-Step Solution

Solution:

Step 1: Define correct age ranges
Child: 0-12 inclusive, Teen: 13-19 inclusive, Adult: 20-64 inclusive, Senior: 65+.
Step 2: Check each option's conditions
IF age <= 12 THEN RETURN 'Child'; ELSIF age <= 19 THEN RETURN 'Teen'; ELSIF age <= 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF; uses <= correctly to include boundary ages. IF age < 12 THEN RETURN 'Child'; ELSIF age < 19 THEN RETURN 'Teen'; ELSIF age < 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF; and D use < which excludes boundary ages incorrectly. IF age <= 12 THEN RETURN 'Child'; ELSEIF age <= 19 THEN RETURN 'Teen'; ELSEIF age <= 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF; uses invalid ELSEIF keyword.
Final Answer:
IF age <= 12 THEN RETURN 'Child'; ELSIF age <= 19 THEN RETURN 'Teen'; ELSIF age <= 64 THEN RETURN 'Adult'; ELSE RETURN 'Senior'; END IF; -> Option C
Quick Check:
Use <= for inclusive ranges and ELSIF keyword [OK]

Quick Trick: Use <= for inclusive ranges; ELSIF, not ELSEIF [OK]

Common Mistakes:

Using ELSEIF instead of ELSIF
Using < instead of <= causing boundary errors
Misplacing ELSE block

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

You want to categorize ages into 'Child' (0-12), 'Teen' (13-19), 'Adult' (20-64), and 'Senior' (65+). Which IF-ELSIF-ELSE block correctly implements this in PL/pgSQL?

Step 1: Define correct age ranges

Step 2: Check each option's conditions

Final Answer:

Quick Check:

Want More Practice?