Checkout the free Window function (in PostgreSQL) course on LearnSQL (FREE only during March 2024) learnsql.com/?ref=thoufiqmohammed

Brilliant! I'm loving this series. It's sending me into areas of SQL I never thought about.

Awesome! Find new concepts with great explaination. Thank you.

So cool! This is the first time I've heard about regular expressions and they seem super useful. Thanks for sharing!

Commendable. Thanks for putting this much effort.

Hi, good Job, it's nice that you place the task / content in file with the data now, so that we know what's the task of the lesson

Good explanation w.r.to regex. Thank you

superb explanation

Your videos are great. Do you think you can also do a small tutorial video on REGEX with a couple more problems? I tried searching in your channel but could not find. It would be really helpful.

Great sir 💯

Great 🤩🤩🤩

What if I want to create a new column in an existing table with a REGEX formula to get the Invoice number from a column in that table.

PySpark 30 Days Challenge of these problems : kzfaq.info/sun/PLqGLh1jt697xzk9LCLL_wFPDZi_xa0xR0

select * from feedback where email like '[a-zA-Z]%@[a-zA-Z]%.[a-zA-Z]%' and email not like '%[@#]%@[a-zA-Z]%.[a-zA-Z]%' and charindex('.',REVERSE(email)) between 3 and 4;