Question: please solve it in SQL 1) Consider the following table and answer the question that follows: (0.5 point) Table Name: PEOPLE ID Firs Age (in
please solve it in SQL 1) Consider the following table and answer the question that follows: (0.5 point) Table Name: PEOPLE ID Firs Age (in years) Tim Anderson Robert Dickson Beth Roberts Nancy Hicken John Smith Mary Show the output of the following SQL query: SELECT First Name, Last Name, CASE WHEN AGE 13 THEN CHILD WHEN AGE 19 THEN TEENAGER WHEN AGE 19 THEN ADULT ELSE 'UNKNOWN' END AS LIFE STAGE FROM PEOPLE Write your answer in this box
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
