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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!