Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE Students(
student_number INT AUTO_INCREMENT PRIMARY KEY,
student_name VARCHAR(100),
dept_name VARCHAR(100),
subject VARCHAR(100),
marks INT
);
INSERT INTO Students (student_name,dept_name,subject,marks) VALUES
('Tom','CS','Programming',90),
('Tom','CS','Database',100),
('Rob','CS','Programming',95),
('Fred','CS','Programming',80),
('Alter','CS','Database',100),
('Jason','CS','Database',98),
('Jason','CS','Programming',80),
('John','English','Literature',75),
('Alicia','English','History',60),
('Sofia','English','History',70),
('Sofia','English','Grammar',70);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment