text: CREATE TABLE student_course_registrations (student_id VARCHAR) -- what is id of students who registered some courses but the least number of courses in these students? SELECT student_id FROM student_course_registrations GROUP BY student_id ORDER BY COUNT(*) LIMIT 1 CREATE TABLE candidates (candidate_id VARCHAR); CREATE TABLE people (first_name VARCHAR, last_name VARCHAR, person_id VARCHAR) -- what are the first name and last name of all candidates? SELECT T2.first_name, T2.last_name FROM candidates AS T1 JOIN people AS T2 ON T1.candidate_id = T2.person_id CREATE TABLE student_course_attendance (student_id VARCHAR); CREATE TABLE students (student_id VARCHAR) -- List the id of students who never attends courses? SELECT student_id FROM students WHERE NOT student_id IN (SELECT student_id FROM student_course_attendance) CREATE TABLE student_course_attendance (student_id VARCHAR) -- List the id of students who attended some courses? SELECT student_id FROM student_course_attendance CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR, course_id VARCHAR) -- What are the ids of all students for courses and what are the names of those courses? SELECT T1.student_id, T2.course_name FROM student_course_registrations AS T1 JOIN courses AS T2 ON T1.course_id = T2.course_id CREATE TABLE student_course_registrations (student_id VARCHAR, registration_date VARCHAR); CREATE TABLE students (student_details VARCHAR, student_id VARCHAR) -- What is detail of the student who most recently registered course? SELECT T2.student_details FROM student_course_registrations AS T1 JOIN students AS T2 ON T1.student_id = T2.student_id ORDER BY T1.registration_date DESC LIMIT 1