LeetCode 1667 Interview SQL Question with Detailed Explanation | Practice SQL

preview_player
Показать описание

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
  1. Everyday Data Science
  2. practice sql interview questions on leetcode
  3. solve sql interview questions
  4. how to solve sql interview questions
  5. leetcode sql queries
  6. leetcode sql questions
Рекомендации по теме
LeetCode 1667 Interview 0:06:28

LeetCode 1667 Interview SQL Question with Detailed Explanation | Practice SQL

1667. Fix Names 0:06:28

1667. Fix Names in a Table | LeetCode | SQL | Solution | Interview Problem

1667. Fix Names 0:03:40

1667. Fix Names in a Table leetcode solution | leetcode sql solutions

Fix Names in 0:07:19

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

LeetCode 1667: Fix 0:11:38

LeetCode 1667: Fix Names in a Table [SQL]

LeetCode - 1667. 0:03:12

LeetCode - 1667. Fix Names in a Table (SQL)

Fix Names in 0:10:24

Fix Names in a Table | 2 Solutions |SQL interview Questions | Leetcode: 1667

MLV Prasad - 0:09:34

MLV Prasad - LeetCode SQL [ EASY ] | 1667 | 'Fix Names in a Table' |

44. Fix Names 0:05:14

44. Fix Names in a Table | SQL Interview Questions and Answers

LeetCode : 1667 0:02:56

LeetCode : 1667 Fix Names in a Table (SQL) | Interview Question

LeetCode 1667 | 0:01:51

LeetCode 1667 | Fix Names in a Table | Concat | Substring | Upper | Lower | Length | SQL

1667. Fix Names 0:02:01

1667. Fix Names in a Table | | LeetCode | Hindi

Fix Names in 0:06:50

Fix Names in a Table - Database - Leetcode 1667 | SQL | Tamil | TamilWebDev | TWD

Leetcode SQL 50 0:06:43

Leetcode SQL 50 Challenge- Episode 38 | 1667. Fix Names in aTable | Leetcode SQL

Crack SQL Interviews 0:06:09

Crack SQL Interviews by these Intense Queries - Complete SQL - Leetcode 1667 | Advanced String Regex

LeetCode 1571 Interview 0:07:57

LeetCode 1571 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1661: Average 0:08:16

LeetCode 1661: Average Time of Process per Machine [SQL]

1667. Fix Names 0:05:50

1667. Fix Names in a Table | sql |#leetcodechallenge #coding

LeetCode Medium 1193 0:09:00

LeetCode Medium 1193 Interview SQL Question with Detailed Explanation

LeetCode Interview SQL 0:05:23

LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 610

LeetCode 1789 Facebook/Meta 0:10:47

LeetCode 1789 Facebook/Meta Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1677 'Product's 0:10:31

LeetCode 1677 'Product's Worth Over Invoices' Interview SQL Question with Detailed Ex...

Решение задачи «1667. 0:04:13

Решение задачи «1667. Fix Names in a Table» на SQL с сайта leetcode.com

Leetcode SQL 50 0:03:29

Leetcode SQL 50 | 1667. Fix Names in a Table Solution

Комментарии
Автор

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

elitebook
Автор

A simple variation:


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

meenayegan
Автор

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

larissayu
Автор

Why can't we go with regexp in oracle?

bhamjjjjjj
Автор

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

phanphancharee