onal Schema: (keys undenined). Student (sid: intyer, snume Stniny, major ístriny, age:inteyer) Hakes( Sid: integer, cid, integer) 2lass(aid:integer, cname: String, instructur:string, roomistring mêet-até time) a) Write the follomng query in SOL. tind the names of students who are enrolled in the classesoffered bu ' Tames waNd', b) Wrile the following query in SQL. Find the names of all Students who are enrolled in. both 'Psychorogy and 'Enylish' classes c) Write the following gueny in sQL. Find the names of all Stucdents nho are enrolled in Psych' but not Enyish'class..

Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order.   (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)

Given the below statement, what would happen if the inner query returned an empty list? SELECT * FROM employees WHERE employee NOT IN(    SELECT employeeId FROM employees WHERE departmentId = 14);

please help me to write the expression for these in access. please.