SQL -Task (SQL Use Cases Naveen Singh)

SQL Use Cases:- Naveen Singh 

Source DE:-

NaveenSQL_Customer_Details


Task-1. Find Gmail users

Query:- Select * From NaveenSQL_Customer_Details Where Email Like '%@gmail.com'



Target DE:- 



Result:- There are 3 out of 10 records has been tested

NaveenSQL_Customer_Details - 20260429_085257_Target_DE



Task-2. Users whose name starts with "A"

Query:- Select * from NaveenSQL_Customer_Details WHERE Name LIKE 'A%'


Target DE:-




Task-3. Users whose name ends with "Singh"

Query:- Select * from NaveenSQL_Customer_Details WHERE Name LIKE '%Singh'


Target DE:-


Task-4. Find users with "sale" in email (campaign filtering)

Query:- Select * from NaveenSQL_Customer_Details Where Email LIKE '%sale%'


Target DE:-

Task-5. Find customers from cities containing "pur"

Query:- Select * from NaveenSQL_Customer_Details Where City LIKE '%pur%'


Target DE:-


Task-6. Target users with mobile numbers ends with 0

Query:- Select * from NaveenSQL_Customer_Details Where Mobile_Number LIKE '%0'


Target DE:-

Task-7. Filter product names containing "Bottle"

Query:- Select * from NaveenSQL_Product_DE Where ProductName LIKE '%Bottle%'

Target DE:-





Task-9. Identify test records

Query:- Select * from NaveenSQL_Customer_Details Where  Email LIKE '%test%'


Target DE:-

Task-10. Domain-based segmentation (Yahoo users)

Query:- Select * from NaveenSQL_Customer_Details Where  Email LIKE '%yahoo.com'


Target DE:-
Task-11. Exclude Gmail users

Query:- Select * from NaveenSQL_Customer_Details Where  Email Not Like '%@Gmail.com'

Target DE:-

Task-12. Exclude unsubscribed users

Query:- Select * from NaveenSQL_Customer_Details Where  status != 'Unsubscribed'



Target DE:-






Unable to work on task number 8,13,16,17,18,19,20...

























































Comments

Post a Comment

Popular posts from this blog

Data filter

Image
Filtered Data Extensions: - https://www.loom.com/share/d9b7ca63c2af4dd5b0137e557fcd306a Generated by applying filters to existing data extensions; they update dynamically based on predefined criteria. USE CASES 1. High-Value Customers Segmentation Scenario : A retail company wants to target customers who have spent more than $500 in the last six months. Solution : Use a filtered data extension to segment customers from a standard DE based on purchase amount and date criteria. Field Name Data Type Length Required Primary Key CustomerID Text 50 Yes Yes FullName Text 100 Yes No EmailAddress EmailAddress N/A Yes No PurchaseAmount Decimal N/A Yes No LastPurchaseDate Date N/A Yes No CustomerID FullName EmailAddress PurchaseAmount LastPurchaseDate CustomerID FullName EmailAddress PurchaseAmount LastPurchaseDate C001 John Doe john.doe@example.com 550.00 2024-12-15 C003 Alice Johnson alice.johnson@example.com 750.00 2024-11-20 Initially created a table for 4 records. After applying the filter...
Read more