Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Customers Without Phone Numbers

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.