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

Extract Initials

Return each user's id and their initials (first letter of first name followed by first letter of last name, uppercase), ordered by id.

Table schema

Users(id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50))

Sample data

id | first_name | last_name
1 | Aman | Sharma
2 | Riya | Patil

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.