Question

I need a table with 4 doctors. With columns that has ID, dept, sex, and experience.
please and thank you

Answer 1

QUERY

CREATE TABLE doctors (id INT PRIMARY KEY, dept VARCHAR(20), sex VARCHAR(10), experience FLOAT);

INSERT INTO doctors VALUES (531, 'Anatomy', 'Female',5);
INSERT INTO doctors VALUES (532, 'Physiology', 'Male',12);
INSERT INTO doctors VALUES (533, 'Neurology', 'Female',6);
INSERT INTO doctors VALUES (534, 'Pathology', 'Male',18);

SELECT * FROM doctors;

Code Screenshot

Output