MySqlQueries.sql

create database hello;
use hello;

CREATE TABLE sampleStudent (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    subject1 INT,
    subject2 INT,
    subject3 INT
);

CREATE TABLE grade_rules (
    id INT AUTO_INCREMENT PRIMARY KEY,
    min_avg INT,
    max_avg INT,
    grade VARCHAR(2)
);
INSERT INTO grade_rules (min_avg, max_avg, grade) VALUES
(90,100,'A'),
(75,89,'B'),
(60,74,'C'),
(40,59,'D'),
(0,39,'E');


CREATE TABLE personality_traits (
    id INT AUTO_INCREMENT PRIMARY KEY,
    grade VARCHAR(2),
    trait VARCHAR(100)
);

INSERT INTO personality_traits (grade, trait) VALUES
('A','Highly Disciplined & Leader'),
('B','Confident & Responsible'),
('C','Hardworking & Consistent'),
('D','Needs Motivation'),
('E','Requires Improvement');