write an SQL query to get the students who are females in STEM and have been admitted…
- User
write an SQL query to get the students who are females in STEM and have been admitted for more than 3 years based on the below schema: "id": a unique identifier for each student "name": the student's name "age": the student's age "gender": the student's gender "address": the student's address "phone_number": the student's phone number "email": the student's email address "admission_date": the date the student was admitted to the university "graduation_date": the expected graduation date for the student "program": the name of the program the student is enrolled in (e.g. "Computer Science") "major": the student's major (e.g. "Computer Science") "minor": the student's minor (e.g. "Mathematics") "GPA": the student's grade point average "advisor_id": the unique identifier of the advisor assigned to the student, with a foreign key reference to the "advisors" table.
Assistant
SELECT s.id, s.name, s.age, s.gender, s.address, s.phone_number, s.email, s.admission_date, s.graduation_date, s.program, s.major, s.minor, s.GPA, s.advisor_id FROM students s JOIN advisors a ON s.advisor_id = a.id WHERE gender = 'Female' AND graduation_date > 3 AND program = 'STEM';
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.