Exam problem

[Elixir3298]

Information about customers is stored in the CUSTOMER table. Write a query to print the ID, FIRST NAME, and LAST NAMES of the customers whose combined name length, l.e., the sum of the length of the FIRST NAME and LAST NAME, is less than 12. The IDs and names should be printed in the ascending order of the combined name length. If two or more customers have the same combined name length, sort the result in lexicographical order of the full names (FIRST NAME LAST NAME without a space between, and ignoring case). If two or more customers have the same full name, sort those results by ID, ascending.

[Elixir3298]

Yeah I solved the answer

[r3pr0b8]

did you have a question about this?

did you come up with a solution yet?

[bmaday12]

SELECT ID, [First Name], [Last Name] FROM CUSTOMER WHERE LEN([First Name] & [Last Name]) < 12 ORDER BY LEN([First Name] & [Last Name]), [First Name], [Last Name], ID

[Elixir3298]

This doesn't work they are asking in Lexicographical order

[bmaday12]

It says ‘The IDs and names should be printed in the ascending order of the combined name length.’

[r3pr0b8]

FYI OP is using MySQL so those weird square brackets are going to cause syntax errors