target-benchmark/spider-queries huggingface dataset:
Database: government_shift (tables: services, customers_and_services)
Question: Which service ( s ) has never been used by any customer ? List their details .
SQL: select service_details from services except select t2.service_details from customers_and_services as t1 join services as t2 on t1.service_id  =  t2.service_id
Database: government_shift (tables: services, customers_and_services)
Question: Find details of the services that no customer has ever used . Return the service details .
SQL: select service_details from services except select t2.service_details from customers_and_services as t1 join services as t2 on t1.service_id  =  t2.service_id
Database: government_shift (tables: analytical_layer)
Question: Find all the layer type codes with their corresponding usage count.
SQL: SELECT analytical_layer_type_code ,  count(*) FROM analytical_layer GROUP BY analytical_layer_type_code
Database: government_shift (tables: analytical_layer)
Question: For each analytical layer, return the analytical layer type code and the number of times it was used.
SQL: SELECT analytical_layer_type_code ,  count(*) FROM analytical_layer GROUP BY analytical_layer_type_code
Database: government_shift (tables: services, customers_and_services)
Question: Find details of all the services that have been marked as `` unsatisfied '' in customers and services details .
SQL: select distinct t1.service_details from services as t1 join customers_and_services as t2 on t1.service_id  =  t2.service_id where t2.customers_and_services_details  =  "unsatisfied"
Database: government_shift (tables: services, customers_and_services)
Question: Which services have been rated as "unsatisfied" in customers and services details? Give me the service_details.
SQL: SELECT DISTINCT t1.service_details FROM services AS t1 JOIN customers_and_services AS t2 ON t1.service_id  =  t2.service_id WHERE t2.customers_and_services_details  =  "Unsatisfied"
Database: vehicle_rent (tables: vehicles)
Question: How many vehicles do we have?
SQL: SELECT count(*) FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: Count the number of vehicles.
SQL: SELECT count(*) FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: Show names for all vehicles in descending order of model year.
SQL: SELECT name FROM vehicles ORDER BY model_year DESC
Database: vehicle_rent (tables: vehicles)
Question: What are the names of all vehicles, ordered by model year descending?
SQL: SELECT name FROM vehicles ORDER BY model_year DESC
Database: vehicle_rent (tables: vehicles)
Question: List all distinct types of powertrain of vehicles.
SQL: SELECT DISTINCT type_of_powertrain FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: What are the different types of powertrains?
SQL: SELECT DISTINCT type_of_powertrain FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: Show name, type of powertrain, and annual fuel cost for all vehicles with model year 2013 or 2014.
SQL: SELECT name ,  type_of_powertrain ,  annual_fuel_cost FROM vehicles WHERE model_year  =  2013 OR model_year  =  2014
Database: vehicle_rent (tables: vehicles)
Question: What are the names, types of powertrains, and yearly fuel costs for vehicles with model years in either 2013 2014?
SQL: SELECT name ,  type_of_powertrain ,  annual_fuel_cost FROM vehicles WHERE model_year  =  2013 OR model_year  =  2014
Database: vehicle_rent (tables: vehicles)
Question: Show types of powertrain with vehicles both from 2014 and 2013.
SQL: SELECT type_of_powertrain FROM vehicles WHERE model_year  =  2014 INTERSECT SELECT type_of_powertrain FROM vehicles WHERE model_year  =  2013
Database: vehicle_rent (tables: vehicles)
Question: What are the types of powertrains that have vehicles that were made in both 2013 and 2014?
SQL: SELECT type_of_powertrain FROM vehicles WHERE model_year  =  2014 INTERSECT SELECT type_of_powertrain FROM vehicles WHERE model_year  =  2013
Database: vehicle_rent (tables: vehicles)
Question: Show all types of powertrain and the number of vehicles in each type.
SQL: SELECT type_of_powertrain ,  count(*) FROM vehicles GROUP BY type_of_powertrain
Database: vehicle_rent (tables: vehicles)
Question: How many vehicles have each type of powertrain?
SQL: SELECT type_of_powertrain ,  count(*) FROM vehicles GROUP BY type_of_powertrain
Database: vehicle_rent (tables: vehicles)
Question: What is the type of powertrain with most number of vehicles.
SQL: SELECT type_of_powertrain FROM vehicles GROUP BY type_of_powertrain ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: vehicles)
Question: Which type of powertrain is most common?
SQL: SELECT type_of_powertrain FROM vehicles GROUP BY type_of_powertrain ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: vehicles)
Question: Show minimum, maximum, and average annual fuel cost for all vehicles.
SQL: SELECT min(annual_fuel_cost) ,  max(annual_fuel_cost) ,  avg(annual_fuel_cost) FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: What are the minimum, maximum, and average annual fuel costs across all vehicles?
SQL: SELECT min(annual_fuel_cost) ,  max(annual_fuel_cost) ,  avg(annual_fuel_cost) FROM vehicles
Database: vehicle_rent (tables: vehicles)
Question: Show name and model year for vehicles with city fuel economy rate less than or equal to highway fuel economy rate.
SQL: SELECT name ,  model_year FROM vehicles WHERE city_fuel_economy_rate  <=  highway_fuel_economy_rate
Database: vehicle_rent (tables: vehicles)
Question: What are the names and model years for vehicles that have a city fuel economy rate less than or equal to its highway fuel economy rate?
SQL: SELECT name ,  model_year FROM vehicles WHERE city_fuel_economy_rate  <=  highway_fuel_economy_rate
Database: vehicle_rent (tables: vehicles)
Question: Show the type of powertrain with at least two vehicles, and the average annual fuel cost for vehicles in each such type.
SQL: SELECT type_of_powertrain ,  avg(annual_fuel_cost) FROM vehicles GROUP BY type_of_powertrain HAVING count(*)  >=  2
Database: vehicle_rent (tables: vehicles)
Question: What are the types of powertrains for which there are two or more vehicles, and what are their average annual fuel costs?
SQL: SELECT type_of_powertrain ,  avg(annual_fuel_cost) FROM vehicles GROUP BY type_of_powertrain HAVING count(*)  >=  2
Database: vehicle_rent (tables: customers)
Question: Show the name, age, membership credit for all customers?
SQL: SELECT name ,  age ,  membership_credit FROM customers
Database: vehicle_rent (tables: customers)
Question: What are the names, ages, and membership credits for all customers?
SQL: SELECT name ,  age ,  membership_credit FROM customers
Database: vehicle_rent (tables: customers)
Question: Show the name and age of the customer with maximum membership credit.
SQL: SELECT name ,  age FROM customers ORDER BY membership_credit DESC LIMIT 1
Database: vehicle_rent (tables: customers)
Question: What is the name and age of the customer with the most membership credit?
SQL: SELECT name ,  age FROM customers ORDER BY membership_credit DESC LIMIT 1
Database: vehicle_rent (tables: customers)
Question: What is the average age for customers with a membership credit above the average?
SQL: SELECT avg(age) FROM customers WHERE membership_credit  >  (SELECT avg(membership_credit) FROM customers)
Database: vehicle_rent (tables: customers)
Question: Return the average age for customers who have membership above the average across all customers.
SQL: SELECT avg(age) FROM customers WHERE membership_credit  >  (SELECT avg(membership_credit) FROM customers)
Database: vehicle_rent (tables: discount)
Question: Show all information for all discounts.
SQL: SELECT * FROM discount
Database: vehicle_rent (tables: discount)
Question: Return all information about discounts.
SQL: SELECT * FROM discount
Database: vehicle_rent (tables: vehicles, renting_history)
Question: Show the name and total hours of renting for each vehicle.
SQL: SELECT T2.name ,  sum(T1.total_hours) FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id
Database: vehicle_rent (tables: vehicles, renting_history)
Question: What are the names and total rental hours for each vehicle?
SQL: SELECT T2.name ,  sum(T1.total_hours) FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id
Database: vehicle_rent (tables: vehicles, renting_history)
Question: Show the name of vehicles with no renting history.
SQL: SELECT name FROM vehicles WHERE id NOT IN (SELECT vehicles_id FROM renting_history)
Database: vehicle_rent (tables: vehicles, renting_history)
Question: What are the names of vehicles that have never been rented?
SQL: SELECT name FROM vehicles WHERE id NOT IN (SELECT vehicles_id FROM renting_history)
Database: vehicle_rent (tables: customers, renting_history)
Question: Show the name of customer with at least two renting history records.
SQL: SELECT T2.name FROM renting_history AS T1 JOIN customers AS T2 ON T1.customer_id  =  T2.id GROUP BY T2.id HAVING count(*)  >=  2
Database: vehicle_rent (tables: customers, renting_history)
Question: What are the names of customers who have two or more records of rental history?
SQL: SELECT T2.name FROM renting_history AS T1 JOIN customers AS T2 ON T1.customer_id  =  T2.id GROUP BY T2.id HAVING count(*)  >=  2
Database: vehicle_rent (tables: vehicles, renting_history)
Question: Show the name and model year of the vehicle with most number of renting history records.
SQL: SELECT T2.name ,  T2.model_year FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: vehicles, renting_history)
Question: What is the name and model year of the vehicle which has been rented the most times?
SQL: SELECT T2.name ,  T2.model_year FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: vehicles, renting_history)
Question: Show the vehicle name with a descending order of total hours of renting.
SQL: SELECT T2.name FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id ORDER BY sum(T1.total_hours) DESC
Database: vehicle_rent (tables: vehicles, renting_history)
Question: What are the names of vehicles, sorted descending by total hours of renting?
SQL: SELECT T2.name FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T2.id ORDER BY sum(T1.total_hours) DESC
Database: vehicle_rent (tables: renting_history, discount)
Question: What is the discount name with most number of renting history records?
SQL: SELECT T2.name FROM renting_history AS T1 JOIN discount AS T2 ON T1.discount_id  =  T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: renting_history, discount)
Question: Return the name of the discount that corresponds to the most rental history records.
SQL: SELECT T2.name FROM renting_history AS T1 JOIN discount AS T2 ON T1.discount_id  =  T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_rent (tables: vehicles, renting_history)
Question: Find the name and powertrain type of the cars that rented for more than 30 total hours.
SQL: SELECT T2.name ,  T2.Type_of_powertrain FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T1.vehicles_id HAVING sum(T1.total_hours)  >  30
Database: vehicle_rent (tables: vehicles, renting_history)
Question: What are the names and powertrain types of cars that have more than 30 total rental hours?
SQL: SELECT T2.name ,  T2.Type_of_powertrain FROM renting_history AS T1 JOIN vehicles AS T2 ON T1.vehicles_id  =  T2.id GROUP BY T1.vehicles_id HAVING sum(T1.total_hours)  >  30
Database: vehicle_rent (tables: vehicles)
Question: Find the average city and highway fuel rates for cars with different powertrain types.
SQL: SELECT avg(City_fuel_economy_rate) ,  avg(Highway_fuel_economy_rate) , Type_of_powertrain FROM vehicles GROUP BY Type_of_powertrain
Database: vehicle_rent (tables: vehicles)
Question: What are the average city fuel economy rate, average highway fuel economy rate for different types of powertrains?
SQL: SELECT avg(City_fuel_economy_rate) ,  avg(Highway_fuel_economy_rate) , Type_of_powertrain FROM vehicles GROUP BY Type_of_powertrain
Database: cre_Students_Information_Systems (tables: student_loans)
Question: What is the average amount of a student loan?
SQL: SELECT avg(amount_of_loan) FROM Student_Loans
Database: cre_Students_Information_Systems (tables: student_loans)
Question: Compute the average amount of student loans.
SQL: SELECT avg(amount_of_loan) FROM Student_Loans
Database: cre_Students_Information_Systems (tables: detention, classes, students)
Question: List the biographical data and student id for the students who take 2 or more classes and the students who have less than 2 detentions.
SQL: SELECT T1.bio_data ,  T1.student_id FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  >=  2 UNION SELECT T1.bio_data ,  T1.student_id FROM Students AS T1 JOIN Detention AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  <  2
Database: cre_Students_Information_Systems (tables: detention, classes, students)
Question: What are the biographical data and student id of the students who either took two or more classes and or have less than two detentions?
SQL: SELECT T1.bio_data ,  T1.student_id FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  >=  2 UNION SELECT T1.bio_data ,  T1.student_id FROM Students AS T1 JOIN Detention AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  <  2
Database: cre_Students_Information_Systems (tables: teachers, classes)
Question: List the details of the teachers who teach some class whose detail has the substring 'data' but do not teach a class whose detail contains the prefix 'net'
SQL: SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.class_details LIKE '%data%' EXCEPT SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.class_details LIKE 'net%'
Database: cre_Students_Information_Systems (tables: teachers, classes)
Question: Which teachers teach a class that has the substring 'data' in its detail but do not teach a class that has prefix 'net' in its detail? Give me the teacher details.
SQL: SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.class_details LIKE '%data%' EXCEPT SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.class_details LIKE 'net%'
Database: cre_Students_Information_Systems (tables: detention, student_loans, students)
Question: List the biographical data of the students who never had a detention or student loan .
SQL: 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)
Database: cre_Students_Information_Systems (tables: detention, student_loans, students)
Question: Which students never had a detention or student loan ? Find their biographical data .
SQL: 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)
Database: cre_Students_Information_Systems (tables: student_loans, achievements)
Question: What are the loan amounts and loan dates of the students who have at least 2 achievements?
SQL: SELECT amount_of_loan ,  date_of_loan FROM Student_Loans WHERE student_id IN ( SELECT student_id FROM Achievements GROUP BY student_id HAVING count(*)  >=  2 )
Database: cre_Students_Information_Systems (tables: student_loans, achievements)
Question: List the amount and date of loan for the students who have two or more achievements.
SQL: SELECT amount_of_loan ,  date_of_loan FROM Student_Loans WHERE student_id IN ( SELECT student_id FROM Achievements GROUP BY student_id HAVING count(*)  >=  2 )
Database: cre_Students_Information_Systems (tables: teachers, classes)
Question: List the detail and id of the teacher who teaches the most courses.
SQL: SELECT T1.teacher_details ,  T1.teacher_id FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id GROUP BY T1.teacher_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: teachers, classes)
Question: What are the detail and id of the teacher who teaches the largest number of courses?
SQL: SELECT T1.teacher_details ,  T1.teacher_id FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id GROUP BY T1.teacher_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: ref_detention_type, detention)
Question: What are the distinct descriptions of all the detentions which have ever happened?
SQL: SELECT distinct(T1.detention_type_description) FROM Ref_Detention_Type AS T1 JOIN Detention AS T2 ON T1.detention_type_code  =  T2.detention_type_code
Database: cre_Students_Information_Systems (tables: ref_detention_type, detention)
Question: Return the distinct descriptions of all the detentions that have happened.
SQL: SELECT distinct(T1.detention_type_description) FROM Ref_Detention_Type AS T1 JOIN Detention AS T2 ON T1.detention_type_code  =  T2.detention_type_code
Database: cre_Students_Information_Systems (tables: ref_address_types, students_addresses, students)
Question: List the personal details and the address type descriptions of all the students.
SQL: SELECT DISTINCT T1.student_details ,  T3.address_type_description FROM Students AS T1 JOIN Students_Addresses AS T2 ON T1.student_id  =  T2.student_id JOIN Ref_Address_Types AS T3 ON T2.address_type_code  =  T3.address_type_code
Database: cre_Students_Information_Systems (tables: ref_address_types, students_addresses, students)
Question: What are the personal details and the address type descriptions of each student?
SQL: SELECT DISTINCT T1.student_details ,  T3.address_type_description FROM Students AS T1 JOIN Students_Addresses AS T2 ON T1.student_id  =  T2.student_id JOIN Ref_Address_Types AS T3 ON T2.address_type_code  =  T3.address_type_code
Database: cre_Students_Information_Systems (tables: addresses, students_addresses, students)
Question: List the the address details and the biographical information of the students.
SQL: SELECT T1.address_details ,  T3.bio_data FROM Addresses AS T1 JOIN Students_Addresses AS T2 ON T1.address_id  =  T2.address_id JOIN Students AS T3 ON T2.student_id  =  T3.student_id
Database: cre_Students_Information_Systems (tables: addresses, students_addresses, students)
Question: What are the address details and biographical information of each student?
SQL: SELECT T1.address_details ,  T3.bio_data FROM Addresses AS T1 JOIN Students_Addresses AS T2 ON T1.address_id  =  T2.address_id JOIN Students AS T3 ON T2.student_id  =  T3.student_id
Database: cre_Students_Information_Systems (tables: transcripts, students)
Question: List the biographical data and the date of the transcript of all the students.
SQL: SELECT T1.bio_data ,  T2.date_of_transcript FROM Students AS T1 JOIN Transcripts AS T2 ON T1.student_id  =  T2.student_id
Database: cre_Students_Information_Systems (tables: transcripts, students)
Question: What are the biographical data and the date of transcript issuance of each student?
SQL: SELECT T1.bio_data ,  T2.date_of_transcript FROM Students AS T1 JOIN Transcripts AS T2 ON T1.student_id  =  T2.student_id
Database: cre_Students_Information_Systems (tables: behaviour_monitoring)
Question: How many students got the most common result in the behavioral monitoring details? Also list the result details.
SQL: SELECT count(DISTINCT student_id) ,  behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: behaviour_monitoring)
Question: Find the most common result in the behavioral monitoring details. What are the count and the details of this result?
SQL: SELECT count(DISTINCT student_id) ,  behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: behaviour_monitoring, students)
Question: Which students not only got the most common result but also got a result obtained by 3 students in behaviour monitoring? List the student's biographical data and details.
SQL: SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1 ) INTERSECT SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details HAVING count(*)  =  3 )
Database: cre_Students_Information_Systems (tables: behaviour_monitoring, students)
Question: Find the biographical data and details of students who got not only the most common result but also a result that is obtained by 3 students in behaviour monitoring.
SQL: SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1 ) INTERSECT SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details HAVING count(*)  =  3 )
Database: cre_Students_Information_Systems (tables: behaviour_monitoring, students)
Question: Which students only got the most common result for his or her all behaviour monitoring details? List the students' biographical information.
SQL: SELECT T1.bio_data FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1 ) EXCEPT SELECT T1.bio_data FROM Students AS T1 JOIN Behaviour_Monitoring AS T2 ON T1.student_id  =  T2.student_id WHERE T2.behaviour_monitoring_details NOT IN ( SELECT behaviour_monitoring_details FROM Behaviour_Monitoring GROUP BY behaviour_monitoring_details ORDER BY count(*) DESC LIMIT 1 )
Database: cre_Students_Information_Systems (tables: students, behaviour_monitoring)
Question: What is the biographical information of the students who got the most common result for their behaviour monitoring details ?
SQL: select t1.bio_data from students as t1 join behaviour_monitoring as t2 on t1.student_id  =  t2.student_id where t2.behaviour_monitoring_details in ( select behaviour_monitoring_details from behaviour_monitoring group by behaviour_monitoring_details order by count(*) desc limit 1 ) except select t1.bio_data from students as t1 join behaviour_monitoring as t2 on t1.student_id  =  t2.student_id where t2.behaviour_monitoring_details not in ( select behaviour_monitoring_details from behaviour_monitoring group by behaviour_monitoring_details order by count(*) desc limit 1 )
Database: cre_Students_Information_Systems (tables: student_events, students)
Question: Which students have gone through any event? List the students' biographical data and event date.
SQL: SELECT T1.bio_data ,  T2.event_date FROM Students AS T1 JOIN Student_Events AS T2 ON T1.student_id  =  T2.student_id