CREATE TABLE students (
id INT,
name VARCHAR(50),
age INT,
grade CHAR(1),
city VARCHAR(50)
);
INSERT INTO students VALUES
(1, 'Aditi', 18, 'A', 'Mumbai'),
(2, 'Rohan', 19, 'B', 'Delhi'),
(3, 'Priya', 18, 'A', 'Mumbai'),
(4, 'Sameer', 20, 'C', 'Bangalore'),
(5, 'Neha', 21, 'B', 'Kolkata');
SELECT name, UPPER(name) as CAPS,age
from students;
Telegram: DB developers channel