Customers Without Phone Numbers
Easy
Filtering & Sorting
Return the id and name of customers whose phone number is missing (NULL), ordered by id.
Table schema
Customers(id INT PRIMARY KEY, name VARCHAR(50), phone VARCHAR(15) NULL)Sample data
id | name | phone
1 | Aman | 9876543210
2 | Riya | NULL
3 | Karan | NULL
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.