simple.sql

create database aws;
use aws;

CREATE TABLE RESTART (
    StudentID int not null AUTO_INCREMENT,
    StudentName varchar(255),
    RestartCity varchar(255),
    GraduationDate Datetime,
    PRIMARY KEY (StudentID)
);

INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Dave','San Antonio','2022-12-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Scott','Santa Maria','2023-12-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Martin','San Lorenzo','2022-12-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Tristin','Berezovka','2023-12-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Rick','Nikolayevka','2023-11-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Victor','La Palma','2022-11-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Ted','Las Delicias','2022-12-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Nick','San Francisco','2022-11-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Morris','Santa Rita','2022-07-22T20:32:33');
INSERT INTO RESTART (StudentName,RestartCity,GraduationDate) VALUES('Tommy','El Porvenir','2022-04-22T20:32:33');



CREATE TABLE CLOUD_PRACTITIONER (
    StudentID int not null,
    CertificationDate Datetime,
    PRIMARY KEY (StudentID)
);

INSERT INTO CLOUD_PRACTITIONER (StudentID,CertificationDate) VALUES(1,'2024-01-22T20:32:33');
INSERT INTO CLOUD_PRACTITIONER (StudentID,CertificationDate) VALUES(2,'2024-02-22T20:32:33');
INSERT INTO CLOUD_PRACTITIONER (StudentID,CertificationDate) VALUES(4,'2024-03-22T20:32:33');
INSERT INTO CLOUD_PRACTITIONER (StudentID,CertificationDate) VALUES(7,'2024-04-22T20:32:33');
INSERT INTO CLOUD_PRACTITIONER (StudentID,CertificationDate) VALUES(9,'2024-05-22T20:32:33');


select RESTART.StudentID, RESTART.StudentName, CLOUD_PRACTITIONER.CertificationDate from RESTART inner join CLOUD_PRACTITIONER where RESTART.StudentID = CLOUD_PRACTITIONER.StudentID;