CREATE TABLE IF NOT EXISTS matt_mct_instructors
(
instructor_id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
phone VARCHAR(255) NOT NULL,
office VARCHAR(255) NOT NULL,
PRIMARY KEY (instructor_id)
);

DROP TABLE IF EXISTS matt_mct_instructors;

INSERT INTO matt_mct_instructors (
instructor_id,
name,
phone,
office
)
VALUES (
NULL, 
('Dehkhoda', 'Rogler', 'Geddes'),
('4629', '8472', '4628'),
('B220E', 'B220J', 'B220T')
);


CREATE TABLE IF NOT EXISTS matt_mct_classes
(
section INT NOT NULL,
course_number VARCHAR(50) NOT NULL,
title VARCHAR(255) NOT NULL,
instructor_id VARCHAR(255) NOT NULL,
PRIMARY KEY (section)
);

DROP TABLE IF EXISTS matt_mct_classes;

INSERT INTO matt_mct_classes (
section,
course_number,
title,
instructor_id
)
VALUES (
NULL, 
('1441', '4118', '4119', '4128'),
('CS80', 'CS55', 'CS60', 'CS85'),
('Internet Programming', 'Java Programming', 'Database Concepts', 'PHP Programming'),
('3', '1', '2', '3')
);



SELECT title, name FROM matt_mct_classes
INNER JOIN matt_mct_instructors USING (instructor_id)
WHERE `title` LIKE '%Programming%' 
ORDER BY name ASC, title ASC;