1. Create a student table and insert data.

SQL

CREATE TABLE Student (

student_id INT PRIMARY KEY,

name VARCHAR(50),

age INT,

major VARCHAR(50)

);

 

INSERT INTO Student (student_id, name, age, major) VALUES

(1, 'Alice', 20, 'Computer Science'),

(2, 'Bob', 21, 'Mathematics'),

(3, 'Charlie', 22, 'Physics'),

(4, 'David', 20, 'Computer Science');