text: CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR) -- What are the id of students who registered course 301? SELECT student_id FROM student_course_attendance WHERE course_id = 301 CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR, date_of_attendance VARCHAR) -- What is the id of the student who most recently registered course 301? SELECT student_id FROM student_course_attendance WHERE course_id = 301 ORDER BY date_of_attendance DESC LIMIT 1 CREATE TABLE addresses (city VARCHAR, address_id VARCHAR); CREATE TABLE people_addresses (address_id VARCHAR) -- Find distinct cities of addresses of people? SELECT DISTINCT T1.city FROM addresses AS T1 JOIN people_addresses AS T2 ON T1.address_id = T2.address_id CREATE TABLE students (student_id VARCHAR); CREATE TABLE addresses (city VARCHAR, address_id VARCHAR); CREATE TABLE people_addresses (address_id VARCHAR, person_id VARCHAR) -- Find distinct cities of address of students? SELECT DISTINCT T1.city FROM addresses AS T1 JOIN people_addresses AS T2 ON T1.address_id = T2.address_id JOIN students AS T3 ON T2.person_id = T3.student_id CREATE TABLE courses (course_name VARCHAR) -- List the names of courses in alphabetical order? SELECT course_name FROM courses ORDER BY course_name CREATE TABLE people (first_name VARCHAR) -- List the first names of people in alphabetical order? SELECT first_name FROM people ORDER BY first_name