SQL Basics: Maths with String Manipulations

Given a demographics table in the following format:

demographics table schema

• id
• name
• birthday
• race

return a single column named calculation where the value is the bit length of name, added to the number of characters in race.

 

 

Solution:

SELECT 
  BIT_LENGTH(name)+
  CHAR_LENGTH(race) 
  AS calculation 
FROM 
  demographics

'BIT_LENGTH' can obtain the bit length.
'CHAR_LENGTH' or 'LENGTH' can obtain the character length.

 

 

Result:

calculation
81
81
81
61
69
105
81
72
89
...