***Mircosoft Access SQL Format*** Which students (by ID number) are from Idaho a
ID: 3815953 • Letter: #
Question
***Mircosoft Access SQL Format***
Which students (by ID number) are from Idaho and have registered for section 2717?
student student_id student_first student_last home_town home_state gpa major class mentor_id 12123 Ari Smith Boise ID 2.80 ITM Junior 26486 12345 Drew Schmidt Meridian KS 2.60 ITM Freshman 56571 15687 Sydney Wilson Idaho City ID 3.50 HIIM Freshman 23232 22255 Sandra Sharda Boise ID 3.80 SCM Junior 24684 22468 Mark Meyer Seattle WA 4.00 HIIM Senior 23232 Dave Martin Portland OR 3.15 HIIM Sophomore 38214 23456 Ashleigh George Vancouver WA 3.30 ITM Junior 44452 24654 Sarah Locke Ogden UT 2.75 SCM Junior 24684 24684 Amanda Evans Nampa ID 3.10 SCM Senior 25643 Jessica Ellis Idaho Falls ID 3.14 SCM Freshman 22255 26486 Albert Thomason McCall ID 3.40 ITM Sophomore 23452 38214 Andrea Jones Meridian ID 3.35 HIIM Junior 22468 44452 Christie Meyer Sacramento CA 3.60 ITM Senior 44466 Trisha Pfannenstiel Boise ID 3.52 HIIM Freshman 58632 45454 Zach Nguyen Boise ID 4.00 HIIM Junior 22468 45456 Namoi Johnson Nampa AZ 3.78 SCM Junior 24684 54687 Tim Peterson Twin Falls ID 2.95 ITM Junior 44452 54907 Altvater Martin Eugene OR 1.90 ITM Senior 55515 Peter Garcia Mountain Home ID 2.80 HIIM Senior 55555 Ethan Rosen Caldwell ID 3.00 SCM Sophomore 45456 56566 Susan Yang Boise ID 3.27 SCM Freshman 45456 56571 Sean Richardson Denver CO 3.40 ITM Sophomore 56789 56789 Steven Carter Weiser ID 3.50 ITM Junior 78788 58632 Justin Kennedy Nampa ID 3.78 HIIM Junior 66324 66324 Aiken Neysa Pocatello ID 3.61 HIIM Senior 70542 Marra Linenberger Salt Lake City UT 3.00 HIIM Freshman 58632 78788 Hannah Jones Boise ID 3.10 ITM Senior 88879 Dan Valencia Pierce ID 2.90 ITM Sophomore 88879 89898 May Smith Ketchum ID 3.64 ITM Junior 78788Explanation / Answer
This query will do what you want.
SELECT student_id
FROM student,registration,section
WHERE (student.home_town=="Idaho City" OR student.home_town=="Idaho Falls") AND registration.section_no==2717 AND registraction.studentid==student.student_id;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.