SQL Basic to advance Part -2
Creating a Classroom dataset for practice
CREATE TABLE classroom
(
rollno int8 PRIMARY KEY,
name varchar(50) NOT NULL,
house char(12) NOT NULL,
grade char(1)
);
INSERT INTO classroom
(rollno, name, house, grade)
VALUES
(1, ‘Sam’, ‘Akash’, ‘B’),
(2, ‘...
ketangrover.hashnode.dev6 min read