Codewars SQL

Kata 7 kyu

SQL: Bytes in String from Ints

Given a table of random numbers as follows:

** numbers table schema **

• id
• number1
• number2
• number3
• number4
• number5

Your job is to return a table in the following format, where each value is the number of bytes in the string representation of the number.

** output table schema **

• octnum1
• octnum2
• octnum3
• octnum4
• octnum5

See expected results for more clarity if required.

Solution:

select length(number1::text) as octnum1,
       length(number2::text) as octnum2,
       length(number3::text) as octnum3,
       length(number4::text) as octnum4,
       length(number5::text) as octnum5
from numbers;

SQL: Bytes in String from Ints | Codewars