Fix Names in a Table | Leetcode 1667 | Crack SQL Interviews in 50 Qs

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on Instagram Handles :- @createwithchirag - instagram.com/createwithchirag/ @learn.with.chirag - instagram.com/learn.with.chirag/ LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/ Let's stay connected and keep the creativity flowing! 💡

[@siddharthakar9369]

nice

[@AakifKhan-h9e]

# Write your MySQL query statement below SELECT user_id , CONCAT(UPPER(SUBSTRING(name,1,1)),LOWER(SUBSTRING(name,2))) AS name FROM Users ORDER BY 1

[@AbhishekGupta-lg5fn]

select user_id, concat(upper(left(name,1)),lower(right(name,-2))) as name from users order by User_id can this be used if no why