LeetCode 1667 Fix Names in a Table
#shorts #DataAnlysis #LeetCode #SQL #Motivation #Education #Programming #Developer #DataScience #Viral #Trending #TechSkils #Skills
Fix Names in a Table - Leetcode 1667
1667. Fix Names in a Table LeetCode in hindi
1667. Fix Names in a Table LeetCode SQL Solution for Interview Problem
Fix Names in a Table | SQL Interview Questions and Answers
LeetCode 1667 Interview SQL Question with Detailed Explanation - Practice SQL
Fix Name Case in SQL in 10 Seconds! π₯
SQL Data Cleaning Trick You MUST Know! π²
SQL Interview Question in 15 Seconds β‘
LeetCode 1667: Fix Names in a Table SQL
πVideo Description π‘
Ever faced messy name formats like aLEx, JOHN, or mArIa in a database?
In real-world analytics, data cleaning is a daily task β and this SQL question tests exactly that.
Question
Write a solution to fix the names so that only the first character is uppercase and the rest are lowercase.
Return the result table ordered by user_id.
π Problem:
Fix user names so that:
β
First letter is UPPERCASE
β
Remaining letters are lowercase
β
Output is ordered by user_id
π§ SQL Concept Used:
UPPER() & LOWER()
SUBSTRING()
CONCAT()
String length handling
Solution
SELECT user_id,
CONCAT(
UPPER(SUBSTRING(name,1,1)),
LOWER(SUBSTRING(name,2,LEN(name)))
) AS name
FROM Users
ORDER BY user_id;
π Asked in Data Analyst & Data Science interviews
π Common real-world SQL cleaning task
π― Why this matters:
β Common SQL interview question
β Real-life data cleaning scenario
β Useful for Data Analysts & Data Scientists
π¬ Comment βSQLβ if you want more interview-level SQL questions
π Like & Share if youβre preparing for data roles
π Watch till the end to fully understand the logic and avoid interview mistakes.
If this helps, LIKE π | COMMENT π¬ | SUBSCRIBE π for more SQL & data content.
WhatsApp Channel:
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i
Instagram:
instagram.com/tech_jroshan/
LinkedIn:
www.linkedin.com/in/roshan-jha-tech/
YouTube:
Β Β Β /Β @tech_jroshanΒ Β
Github:-
github.com/jroshancode
πKeywords
fix names in sql, sql string functions, sql data cleaning, leetcode 1667 sql, sql interview shorts, sql substring upper lower, sql name formatting, sql for data analysis, sql for data science, sql text functions, sql beginner tricks, sql shorts
SQL, SQL Shorts, SQL Interview, SQL Tutorial, Data Analysis SQL, Data Science SQL, SQL Cleaning, SQL Functions, LeetCode SQL, Coding Sho