LeetCode 1667 Interview SQL Question with Detailed Explanation | Practice SQL

Question: leetcode.com/p...
In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.
LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.
If you found this helpful, Like and Subscribe to the channel for more content.
#LeetCodeSQL #FAANG #SQLinterviewQuestions

[@meenayegan6634]

A simple variation: select user_id, upper(left(name , 1))+ lower(substring(name,2,len(student_name)-1)) from Users order by user_id

[@elitebook9473]

wow sir you are awesome you explain everthing in simple way your teaching manner i love it please keep it up sir we need you

[@EverydayDataScience]

Glad that you are finding the videos helpful. Thanks for such kind words.

[@larissayu8853]

can we first lower the name column and then upper the first letter? upper(substring(lower(name),1,1))

[@shubhamsukum]

Arigato!!

[@bhamjjjjjj]

Why can't we go with regexp in oracle?

[@phanphancharee4838]

Why we Len-1 ? Alice :len = 5 ? Or it counts 0,1,2,3,4?

[@EverydayDataScience]

Because we are starting from 2nd letter. So for Alice, we extracted out the first letter ‘a’ and used upper to make it capital. Now everything after letter ‘a’ needs to be small. So since we are starting from second letter that is ‘l’, what is the remaining number of characters? It is LICE , which is 4. In other words, LENGTH(Alice)-1 I hope this clears your doubt.

[@pranavjadhav4671]

we are staring from 2 so it goes till lenght(name)which is one letter exceed like (alice) from 2 which from l to lenght(name)=5 which is "lice_" one extra space so length(name)-1