In this video we will discuss a famous SQL interview problem where we need to segregate first name , middle name and last name from the customer name. I am going to explain the solution in a step by step manner. script: create table customers (customer_name varchar(30)) insert into customers values ('Ankit Bansal') ,('Vishal Pratap Singh') ,('Michael'); Zero to hero(Advance) SQL Aggregation: Most Asked Join Based Interview Question: Solving 4 Trick SQL problems: Data Analyst Spotify Case Study: Top 10 SQL interview Questions: Interview Question based on FULL OUTER JOIN: Playlist to master SQL : Rank, Dense_Rank and Row_Number: #sql #dataengineer