How can to create a query in HIVE.

There a table with columns name, age (0-100), address.

In the result use Case statement when age is 80 + = 'old' while 0-18 = 'young'

Count the 'old' and 'young', so the resulting tables would look like:

category count

young 30

old 50

thanks!