Question:
Count the Characters in Review Comments
Write a query to display the total count of characters in the review comment given by the guest. Display the result set in the ascending order of count of characters. Give alias name as COMMENTS_LENGTH.
Code:
Main.sql
select length(comments) as COMMENTS_LENGTH from review order by COMMENTS_LENGTH;