Very basic SQL question. Sorry for the blurry image. Consider the following SQL

Question

Very basic SQL question. Sorry for the blurry image.

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.) Assume that fields Min and Max are both numeric and aa a111 cation is a character string. Now assume that you want to add a new row to the table lo classily any level b 40 as Unusually Low Complete the following SQL statement so that it will add Such a row to the table

Explanation / Answer

INSERT INTO LDL_Cholesterol

values('Unusually low ',0,39);

this sql statement will add another row in the table with classification as unusually low and with min value as 0 and max value as 39 as we have to sepcify for below 40 so the range would be 0-39

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.