SELECT Exam_Date ,  Exam_Name FROM Exams WHERE Subject_Code != 'Database'
Find the exams whose subject code is not "Database". What are the exam dates and exam names?
CREATE TABLE Students (
Student_ID INTEGER NOT NULL,
First_Name VARCHAR(255),
Middle_Name VARCHAR(255),
Last_Name VARCHAR(255),
Gender_MFU CHAR(1),
Student_Address VARCHAR(255),
Email_Adress VARCHAR(255),
Cell_Mobile_Phone VARCHAR(255),
Home_Phone VARCHAR(255),
PRIMARY KEY (Student_ID)
);
CREATE TABLE Questions (
Question_ID INTEGER NOT NULL,
Type_of_Question_Code VARCHAR(15) NOT NULL,
Question_Text VARCHAR(255),
PRIMARY KEY (Question_ID)
);
CREATE TABLE Exams (
Exam_ID INTEGER NOT NULL,
Subject_Code CHAR(15) NOT NULL,
Exam_Date DATETIME,
Exam_Name VARCHAR(255),
PRIMARY KEY (Exam_ID)
);
CREATE TABLE Questions_in_Exams (
Exam_ID INTEGER NOT NULL,
Question_ID INTEGER NOT NULL,
PRIMARY KEY (Exam_ID, Question_ID),
FOREIGN KEY (Question_ID) REFERENCES Questions (Question_ID),
FOREIGN KEY (Exam_ID) REFERENCES Exams (Exam_ID)
);
CREATE TABLE Valid_Answers (
Valid_Answer_ID INTEGER NOT NULL,
Question_ID INTEGER NOT NULL,
Valid_Answer_Text VARCHAR(255),
PRIMARY KEY (Valid_Answer_ID),
FOREIGN KEY (Question_ID) REFERENCES Questions (Question_ID)
);
CREATE TABLE Student_Answers (
Student_Answer_ID INTEGER NOT NULL,
Exam_ID INTEGER NOT NULL,
Question_ID INTEGER NOT NULL,
Student_ID INTEGER NOT NULL,
Date_of_Answer DATETIME,
Comments VARCHAR(255),
Satisfactory_YN VARCHAR(1),
Student_Answer_Text VARCHAR(255),
PRIMARY KEY (Student_Answer_ID),
FOREIGN KEY (Student_ID) REFERENCES Students (Student_ID),
FOREIGN KEY (Exam_ID, Question_ID) REFERENCES Questions_in_Exams (Exam_ID,Question_ID)
);
CREATE TABLE Student_Assessments (
Student_Answer_ID VARCHAR(100) NOT NULL,
Valid_Answer_ID INTEGER NOT NULL,
Student_Answer_Text VARCHAR(255),
Satisfactory_YN CHAR(1),
Assessment VARCHAR(40),
PRIMARY KEY (Student_Answer_ID),
FOREIGN KEY (Valid_Answer_ID) REFERENCES Valid_Answers (Valid_Answer_ID)
);
INSERT INTO `Students` (`Student_ID`, `First_Name`, `Middle_Name`, `Last_Name`, `Gender_MFU`, `Student_Address`, `Email_Adress`, `Cell_Mobile_Phone`, `Home_Phone`) VALUES (5, 'Wilbert', 'Mia', 'Conroy', 'F', '2908 Breana Streets Suite 638', 'rjast@example.com', '620.962.4384x340', '017-084-5752x96504')
INSERT INTO `Questions` (`Question_ID`, `Type_of_Question_Code`, `Question_Text`) VALUES (285, 'Single Choice', 'When is middle age period')
INSERT INTO `Exams` (`Exam_ID`, `Subject_Code`, `Exam_Date`, `Exam_Name`) VALUES (1, 'Art History', '2016-01-28 02:03:40', '2016 Spring AH')
INSERT INTO `Questions_in_Exams` (`Exam_ID`, `Question_ID`) VALUES (1, 321)
INSERT INTO `Valid_Answers` (`Valid_Answer_ID`, `Question_ID`, `Valid_Answer_Text`) VALUES (1, 321, 'ABC')
INSERT INTO `Student_Answers` (`Student_Answer_ID`, `Exam_ID`, `Question_ID`, `Student_ID`, `Date_of_Answer`, `Comments`, `Satisfactory_YN`, `Student_Answer_Text`) VALUES (127, 1,321, 52, '2017-08-13 06:03:03', 'Normal', '0', 'D')
INSERT INTO `Student_Assessments` (`Student_Answer_ID`, `Valid_Answer_ID`, `Student_Answer_Text`, `Satisfactory_YN`, `Assessment`) VALUES ('162', 3, 'B', '0', 'Very Good')