The example is not particularly impressive. The SQL equivalent is much easier to understand, which means it is easier to maintain. Number of lines is not an interesting metric; understandability and maintainability are more important.
Traditionally SQL uses a lot of lines because you put one thing per line, but so what?