PrepAway - Latest Free Exam Questions & Answers

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created
as follows: How can this function be used to convert average temperature (AVG_TEMP)
data stored in a table called CLIMATE_INFO?

PrepAway - Latest Free Exam Questions & Answers

A.
CALL conv_temp(climate_info.avg_temp);

B.
CALL convert_ftoc(climate_info.avg_temp);

C.
SELECT conv_temp(avg_temp) FROM climate_info;

D.
SELECT convert_ftoc(avg_temp) FROM climate_info;


Leave a Reply