Leetocode 1517. Find Users With Valid E-Mails | SQL | Hindi | Leetcode | TOP 50 SQL LEETCODE | DATA скачать в хорошем качестве

Leetocode 1517. Find Users With Valid E-Mails | SQL | Hindi | Leetcode | TOP 50 SQL LEETCODE | DATA

#leetcode #sql #interviewquestions #dataengineering #dataanalytics Q. Write a solution to find the users who have valid emails. A valid e-mail has a prefix name and a domain where: The prefix name is a string that may contain letters (upper or lower case), digits, underscore '_', period '.', and/or dash '-'. The prefix name must start with a letter. The domain is '@leetcode.com'. Return the result table in any order. The result format is in the following example. Solution - Note - this is sample code.. we cannot use angle brackets in description, so I removed them from the code. select * from users where mail regexp '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode[.]com$' and BINARY mail like '%@leetcode.com' -- ^ start -- $ end -- * zero or any number of items -- [a-zA-Z0-9_.-] can have a-z or A-Z or 0-9 or _ or . or - -- like is case insensitive so used BINARY to make it case sensitive #leetcodesql #FAANG #SQLinterviewQuestions #sql #sqlinterviewquestions #sqlinterviewquestionsandanswers #sqlquestions Related keywords sql interview questions sql interview questions and answers sql interview sql questions and answers top sql questions sql interview questions for freshers sql interview questions for beginners sql interview questions for experienced intermediate level sql interview questions sql queries interview questions and answers sql interview preparation sql basic questions sql questions sql query interview questions sq