Question

Consider the following SQL table, called LDL_Cholesterol,of LDL Cholesterol Levels and their classifications. (NB: Although the classifications in the table are generally accepted, a fictitious maximum has been added to the Very High Risk category for the purpose of this exercise.) Classification Mín Max Desirable 40 Optimal 100 129 130 159 Borderline High 160 High Risk 189 Very High Risk 190 250 Assume that fields Min and Max are both numeric and Classification is a character string. Now assume that you want to change the classification ‘Very High Risk' to ‘Get Help!'. Complete the following SQL statement so that it changes the table accordingly SET UPDATE WHERE

Answer 1

create table LDL_Cholesterol(Classification varchar(25),
                           Minimum int,
                           Maximum int);

insert into LDL_Cholesterol values('Desirable',40,99);
insert into LDL_Cholesterol values('Optimal',100,129);
insert into LDL_Cholesterol values('Borderline High',130,159);
insert into LDL_Cholesterol values('High Risk',160,189);
insert into LDL_Cholesterol values('Very High Risk',190,250);

select Classification,minimum "Min",maximum "Max"
from LDL_Cholesterol;

update LDL_Cholesterol set Classification='Get Help!'
where Classification='Very High Risk';

select Classification,minimum "Min",maximum "Max"
from LDL_Cholesterol;

SQL> select Classification, mininum "Min",maximum "Max" 2 From LDL Cholesterol; Min CLASSIFICATION Max Desirable 40 Optimal Borderline Higt High Risk Uery High Risk 100 129 130 16 8 159 189 258 190 SQL> update LDL_Cholesterol set Classification-'Get Help?' 2 where Classification- Uery High Risk'; 1 row updated. SQL> select Classification, mininum "Min",maximum "Max" 2 From LDL Cholesterol; Min CLASSIFICATION Max Desirable 40 Optimal Borderline Higt High Risk Get Help? 100 129 159 130 16 8 189 258 190