select Name||'('||SUBSTR(Occupation, 1, 1)||')' from OCCUPATIONS
order by Name;
select 'There are a total of '||count(Occupation)||' '||LOWER(Occupation)||'s.' cnt from OCCUPATIONS
group by Occupation
order by count(Occupation), Occupation;
order by count(Occupation) 이걸로 안하고 그냥 위에 만들어논 cnt로 order by 할려고함
그리고 샘플에 소문자로 해논거 못보고 계속 왜 안되지 이러고 있었네..
LOWER(Occupation) 해결