Meta
Medium
Data ScientistWrite SQL to localize anomaly and funnel
Data Manipulation (SQL/Python)
0
0
October 13, 2025
SQL String Manipulation Interview Questions
String manipulation questions test your ability to clean, parse, and normalize text data.
Expect SUBSTRING, SPLIT, CONCAT, TRIM, and pattern matching with LIKE or regex.
Interviewers care about correctness, edge cases, and readable logic.
47Questions
24Companies
Common SQL string manipulation interview patterns
- Extracting domains or prefixes from strings
- Splitting delimited fields into components
- Normalizing case and trimming whitespace
- Pattern matching with LIKE or regex
- Building formatted strings with CONCAT
SQL string manipulation interview questions
Filter and sort
CVS Health
Medium
Data ScientistAggregate radiology spend and derive fiscal month
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistProduce dating profile funnel report by cohort
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute French DAU video-call percentage yesterday
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Upstart
Medium
Data ScientistWrite monthly touches and last-touch SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
TikTok
Medium
Data ScientistCompare SQL counts, windows, and NULL semantics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for comment analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistImpute, join, and upsert using SQL and Python
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite advanced SQL for sales support analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Thumbtack
Medium
Data ScientistWrite complex joins and window functions
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute shop visibility and intent metrics in SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Airbnb
Medium
Data ScientistCompute browsing metrics in Python from logs
Data Manipulation (SQL/Python)
0
0
October 13, 2025
PayPal
Medium
Data ScientistWrite SQL to flag Venmo ATO
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for social feed metrics and ties
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Freddie Mac
Medium
Data ScientistDesign SQL cleaning, mapping, dedupe, and keying
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute 7-day views and reactions by relationship
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Freddie Mac
Medium
Data ScientistAssess SQL cleaning, mapping, joins, keys, and DDL/DML
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Stripe
Medium
Software EngineerDesign payment-to-invoice matcher with priorities
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Stripe
Medium
Software EngineerCompute costs with validation and sorting in Python
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Bloomberg
Medium
Data EngineerWrite PostgreSQL string-manipulation query
Data Manipulation (SQL/Python)
0
0
September 6, 2025
Common mistakes with SQL string manipulation
- Off-by-one errors in SUBSTRING indexes
- Not handling NULL or empty strings
- Using LIKE when regex is needed (or vice versa)
- Ignoring leading and trailing whitespace
- Assuming fixed string lengths
How string manipulation questions are evaluated in interviews
Correct parsing and edge-case handling are the main signals.
Explain how you handle NULLs and inconsistent formats.
Prefer clear, readable logic over clever hacks.