SQL Problem Solving: Splitting List of Sweets with STRING_SPLIT & CROSS_APPLY | Step-by-Step

Dive into the world of SQL problem-solving with our latest tutorial! In this session, we tackle the challenge of splitting a "list of sweets" into individual records using STRING_SPLIT and CROSS_APPLY. Follow along as we unravel the intricacies of SQL queries, providing a step-by-step guide to address real-world scenarios.

📋 Problem Description:
The task involves working with a "customer" table, where we need to split the "fabSweets" column containing a list of sweets into separate records. We employ the powerful STRING_SPLIT function and showcase the versatility of CROSS_APPLY to achieve this data transformation.

Table creation & insertion script:
CREATE TABLE customer(
name VARCHAR(500),
fabSweets VARCHAR(1000)
);

INSERT INTO customer VALUES('Ram Kumar','Laddoo,Sandesh'),
('Yogesh Kadam','Jalebi'),
('Vivek Rana',null),
('Palak Dubey','Mysore Pak,Barfi,Jalebi');

👉 Don't forget to like, share, and subscribe for more SQL tutorials and problem-solving sessions! Explore additional challenges in our SQL playlist and enhance your SQL skills.

#sql #problemsolving #interview #sqlprogramming #sqlqueries