select bio_data from students where student_id not in (select t1.student_id from students as t1 join detention as t2 on t1.student_id  =  t2.student_id union select t1.student_id from students as t1 join student_loans as t2 on t1.student_id  =  t2.student_id)
Which students never had a detention or student loan ? Find their biographical data .
CREATE TABLE Students (
`student_id` INTEGER NOT NULL,
`bio_data` VARCHAR(255) NOT NULL,
`student_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`student_id`)
);
CREATE TABLE Transcripts (
`transcript_id` INTEGER NOT NULL,
`student_id` INTEGER NOT NULL,
`date_of_transcript` DATETIME(3),
`transcript_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`transcript_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id)
);
CREATE TABLE Behaviour_Monitoring (
`behaviour_monitoring_id` INTEGER NOT NULL,
`student_id` INTEGER NOT NULL,
`behaviour_monitoring_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`behaviour_monitoring_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id)
);
CREATE TABLE Addresses (
`address_id` INTEGER NOT NULL,
`address_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`address_id`)
);
CREATE TABLE Ref_Event_Types (
`event_type_code` CHAR(10) NOT NULL,
`event_type_description` VARCHAR(255) NOT NULL,
PRIMARY KEY (`event_type_code`)
);
CREATE TABLE Ref_Achievement_Type (
`achievement_type_code` CHAR(15) NOT NULL,
`achievement_type_description` VARCHAR(80),
PRIMARY KEY (`achievement_type_code`)
);
CREATE TABLE Ref_Address_Types (
`address_type_code` CHAR(10) NOT NULL,
`address_type_description` VARCHAR(255) NOT NULL,
PRIMARY KEY (`address_type_code`)
);
CREATE TABLE Ref_Detention_Type (
`detention_type_code` CHAR(10) NOT NULL,
`detention_type_description` VARCHAR(80),
PRIMARY KEY (`detention_type_code`)
);
CREATE TABLE Student_Events (
`event_id` INTEGER NOT NULL,
`event_type_code` CHAR(10) NOT NULL,
`student_id` INTEGER NOT NULL,
`event_date` DATETIME(3),
`other_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`event_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id),
FOREIGN KEY (event_type_code) REFERENCES Ref_Event_Types (event_type_code)
);
CREATE TABLE Teachers (
`teacher_id` INTEGER NOT NULL,
`teacher_details` VARCHAR(255),
PRIMARY KEY (`teacher_id`)
);
CREATE TABLE Student_Loans (
`student_loan_id` INTEGER NOT NULL,
`student_id` INTEGER NOT NULL,
`date_of_loan` DATETIME(3),
`amount_of_loan` DECIMAL(15,4),
`other_details` VARCHAR(255),
PRIMARY KEY (`student_loan_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id)
);
CREATE TABLE Classes (
`class_id` INTEGER NOT NULL,
`student_id` INTEGER NOT NULL,
`teacher_id` INTEGER NOT NULL,
`class_details` VARCHAR(255) NOT NULL,
PRIMARY KEY (`class_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id),
FOREIGN KEY (teacher_id) REFERENCES Teachers (teacher_id)
);
CREATE TABLE Students_Addresses (
`student_address_id` INTEGER NOT NULL,
`address_id` INTEGER NOT NULL,
`address_type_code` CHAR(10) NOT NULL,
`student_id` INTEGER NOT NULL,
`date_from` DATETIME(3),
`date_to` DATETIME(3),
PRIMARY KEY (`student_address_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id),
FOREIGN KEY (address_id) REFERENCES Addresses (address_id),
FOREIGN KEY (address_type_code) REFERENCES Ref_Address_Types (address_type_code)
);
CREATE TABLE Detention (
`detention_id` INTEGER NOT NULL,
`detention_type_code` CHAR(10) NOT NULL,
`student_id` INTEGER NOT NULL,
`datetime_detention_start` DATETIME(3),
`datetime_detention_end` DATETIME(3),
`detention_summary` VARCHAR(255),
`other_details` VARCHAR(255),
PRIMARY KEY (`detention_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id),
FOREIGN KEY (detention_type_code) REFERENCES Ref_Detention_Type (detention_type_code)
);
CREATE TABLE Achievements (
`achievement_id` INTEGER NOT NULL,
`achievement_type_code` CHAR(15) NOT NULL,
`student_id` INTEGER NOT NULL,
`date_achievement` DATETIME(3),
`achievement_details` VARCHAR(255),
`other_details` VARCHAR(255),
PRIMARY KEY (`achievement_id`),
FOREIGN KEY (student_id) REFERENCES Students (student_id),
FOREIGN KEY (achievement_type_code) REFERENCES Ref_Achievement_Type (achievement_type_code)
);
INSERT INTO Students (`student_id`, `bio_data`, `student_details`) VALUES (276, 'Camila', 'Suite 076')
INSERT INTO Transcripts (`transcript_id`, `student_id`, `date_of_transcript`, `transcript_details`) VALUES (131, 669, '1973-08-09 00:00:00.000', 'Good')
INSERT INTO Behaviour_Monitoring (`behaviour_monitoring_id`, `student_id`, `behaviour_monitoring_details`) VALUES (142, 435, 'A')
INSERT INTO Addresses (`address_id`, `address_details`) VALUES (0, '607 Nikita Cape Suite 449')
INSERT INTO Ref_Achievement_Type (`achievement_type_code`, `achievement_type_description`) VALUES ('Athletic', 'Athletic')
INSERT INTO Ref_Address_Types (`address_type_code`, `address_type_description`) VALUES ('CO', 'College')
INSERT INTO Ref_Detention_Type (`detention_type_code`, `detention_type_description`) VALUES ('After School', 'After School')
INSERT INTO Ref_Event_Types (`event_type_code`, `event_type_description`) VALUES ('Exam', 'Exam')
INSERT INTO Student_Events (`event_id`, `event_type_code`, `student_id`, `event_date`, `other_details`) VALUES (146, 'Exam', 287, '2008-08-15 22:16:17.000', '')
INSERT INTO Teachers (`teacher_id`, `teacher_details`) VALUES (115, 'Jon')
INSERT INTO Student_Loans (`student_loan_id`, `student_id`, `date_of_loan`, `amount_of_loan`, `other_details`) VALUES (165, 777, '1980-01-06 00:00:00.000', '2216.1500', NULL)
INSERT INTO Classes (`class_id`, `student_id`, `teacher_id`, `class_details`) VALUES (114, 435, 253, 'databases')
INSERT INTO Students_Addresses (`student_address_id`, `address_id`, `address_type_code`, `student_id`, `date_from`, `date_to`) VALUES (11, 94, 'HM', 984, '2011-06-29 09:45:39.000', '2018-03-22 07:50:48.000')
INSERT INTO Detention (`detention_id`, `detention_type_code`, `student_id`, `datetime_detention_start`, `datetime_detention_end`, `detention_summary`, `other_details`) VALUES (133, 'Lunch', 361, '2012-03-18 09:49:33.000', '2011-09-15 05:58:59.000', NULL, NULL)
INSERT INTO Achievements (`achievement_id`, `achievement_type_code`, `student_id`, `date_achievement`, `achievement_details`, `other_details`) VALUES (153, 'Athletic', 777, 2013, 'Gold', NULL)