THE LENGTH OF THE COUNTRY NAME VALUE FOR EACH ROW IS TO BE CALCULATED USING P AR T IITHE LENGTH FUNCTION

2. The length of the country name value for each row is to be calculated using

P AR T II

the LENGTH function. The average length may be determined using the AVG

function. It may be rounded to the nearest whole number using the ROUND

function. A possible solution is

select round(avg(length(country_name))) average_country_name_lengthfrom countries;