Pattern Matching with LIKE
Easy
Filtering & Sorting
Find the names of customers whose name starts with the letter 'A' and who live in 'Pune'. Order the result alphabetically.
Table schema
Customers(id INT PRIMARY KEY, name VARCHAR(50), city VARCHAR(50))Sample data
id | name | city
1 | Aman | Pune
2 | Anita | Mumbai
3 | Rahul | Delhi
4 | Alok | Pune
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.