You are given a database in a MS Access file called ‘Database Query Assignment’

Question

You are given a database in a MS Access file called ‘Database Query Assignment’ that contains data collected in a school of business. The school of business hired you as a data analyst to answer questions in order to help them make business decisions that will help better prepare students for future job placements. Write the SQL statement in the SQL Statement column for each query

List the students still searching for jobs.

List the jobs that are currently available.

ame Offer ame er IfRep_GPA Recruiter dentStatus FirstName LastName Interview bID terview_Date dentSkills SID rview_Time JobSkills ID ID ID Skill bStatus JobDescription RID killName tion

Explanation / Answer

1. SELECT Student.S_FirstName FROM Student INNER JOIN Offer ON Student.SID = Offer.SID WHERE Offer.OfferStatus = 'Not Hired'.

:- I am assuming that offer status have values Hired and Not Hired. And Not Hired students are still searching for jobs

2. SELECT JobTitle FROM Jobs WHERE JobStatus = 'Available'

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.