text: CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR, date_of_attendance VARCHAR); CREATE TABLE courses (course_id VARCHAR, course_name VARCHAR) -- List the id of students who attended statistics courses in the order of attendance date. SELECT T2.student_id FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T1.course_name = "statistics" ORDER BY T2.date_of_attendance CREATE TABLE weather (date VARCHAR, max_temperature_f INTEGER) -- Give me the dates when the max temperature was higher than 85. SELECT date FROM weather WHERE max_temperature_f > 85 CREATE TABLE station (name VARCHAR, lat INTEGER) -- What are the names of stations that have latitude lower than 37.5? SELECT name FROM station WHERE lat < 37.5 CREATE TABLE station (city VARCHAR, lat INTEGER) -- For each city, return the highest latitude among its stations. SELECT city, MAX(lat) FROM station GROUP BY city CREATE TABLE trip (start_station_name VARCHAR, end_station_name VARCHAR, id VARCHAR) -- Give me the start station and end station for the trips with the three oldest id. SELECT start_station_name, end_station_name FROM trip ORDER BY id LIMIT 3 CREATE TABLE station (lat INTEGER, long INTEGER, city VARCHAR) -- What is the average latitude and longitude of stations located in San Jose city? SELECT AVG(lat), AVG(long) FROM station WHERE city = "San Jose" CREATE TABLE trip (id VARCHAR, duration VARCHAR) -- What is the id of the trip that has the shortest duration? SELECT id FROM trip ORDER BY duration LIMIT 1