CREATE DATABASE schoolmanagement;
USE schoolmanagement;

CREATE TABLE students(
    id INT,
    name VARCHAR(50),
    age INT,
    marks INT
);
INSERT INTO students(id, name, age, marks)
VALUES
(1, 'Rahul', 15, 85),
(2, 'Priya', 14, 92),
(3, 'Aman', 16, 78);

SELECT * FROM students;

SELECT name FROM students;

SELECT name FROM students
WHERE marks>80;

SElECT * FROM students
ORDER BY marks DESC;

SELECT COUNT(*) FROM students;

UPDATE students
SET marks = 80

WHERE id = 1;

SELECT marks FROM students;

CREATE TABLE teachers(
    id INT,
    name VARCHAR(50),
    experience INT,
    subject VARCHAR(50)
);

INSERT INTO teachers(id, name, experience, subject)
VALUES
(1, 'Prof. Anamika', 7, 'English'),
(2, 'Prof. John', 12, 'Math'),
(3, 'Prof, Green', 5, 'Science');

SELECT * FROM teachers;

SELECT name, subject FROM teachers;
SELECT name, experience+2 FROM teachers;
SELECT name, marks + 5 AS updated_marks
FROM students;

SELECT * FROM teachers 
WHERE subject!='Math' ;

ALTER TABLE teachers
ADD age INT;

SELECT * FROM students
WHERE age>10 AND marks>80;

SELECT * FROM students
WHERE age>10 OR marks>80;

UPDATE teachers
SET age = 50
WHERE id = 1;

UPDATE teachers
SET age = 34
WHERE id = 2;

UPDATE teachers
SET age = 40
WHERE id = 3;