Capgemini SQL Interview Question | Count Members in a Comma-Separated String

In this video, I have discussed how to solve the SQL Interview Questions: "Given a Teams table with columns TeamID (integer) and Members (comma-separated string of names), write a query to calculate and display the total number of members in each team." -- Create Table Teams CREATE TABLE Teams ( TeamID INT PRIMARY KEY, Members TEXT ); -- Insert Data INSERT INTO Teams (TeamID, Members) VALUES (1, 'Chris, Evan, Marty, Eva'), (2, 'Jake, Olivia'), (3, 'Sophia, Liam, Noah, Emma'), (4, 'Ava, Lucas, Mia, Ethan, Amelia'), (5, 'Benjamin, Charlotte'), (6, 'Harper, Henry, Evelyn, Daniel, Ella'), (7, 'Michael, Emily, Alexander'), (8, 'James, Abigail, William, Isabella, Jack, Grace'), (9, 'Sebastian, Chloe'), (10, 'David, Lily, Samuel, Madison'); SQL Interview QnAs: https://www.youtube.com/playlist?list=PLL871c9yfLoimvglCSz6UQoqLJcFBJGKo ***Join our Telegram Group for regular updates on Jobs and Data Science materials: https://t.me/skilltechathon Follow us on Instagram: https://www.instagram.com/skilltechathon/ #sql #postgresql #deloitte #deloittejobs #capgeminihiring #mysql #interview #dataengineering #dataanalytics #dataanalysis #capgemini #capgeminijobs #sqlfordataengineer #jobinterview #coding #programming #technicalinterview