Untitled

create database lab3

CREATE TABLE teacher (
    teacher_id INT  PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    hire_date DATE,
    subject VARCHAR(50),
    phone_number VARCHAR(15),
    salary DECIMAL(10, 2),
    department_id INT
);
Select * From teacher
select * From teacher order by salary