The school of business hired you as a data analyst to answer questions in order

Question

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. Wrlte the SQL statement In the SQL Statement column for each query mpamY ID C Name Street City State S FirstName S Middel URL S State Recruiter Major Phone Email SkID DobID oblD RID SQL Statement Query Question 1. List all students who graduate in May 10 2002 and are Accounting majors. 2. List all students who accepted an intermship, including the job title, and the 3. List the average salary offer by major. 4. List the interviews scheduled for December 1 2001 by company 5. List the average bonus offer by company 6. List the jobs that are currently available. 7. List all students who received more than one offer. 8. List the students still searching for jobs. 9. List the jobs name of the company that require leadership and communication

Explanation / Answer

If you have any doubts, please give me comment...

-- 1)

SELECT *

FROM Student

WHERE datename(month, GradDate) ='May' AND YEAR(GradDate) = 2002 AND Major = 'Accounting';

-- 2)

SELECT SID, S_FirstName, S_Middle1, S_LastName, JobTitle, C_Name

FROM Student S, Offer O, Job J, Recruiter R, Company C

WHERE S.SID = O.SID AND O.JobID = J.JobID AND J.RID = R.RID AND R.CID = C.CID AND Offerstatus = 'Accepted';

--3)

SELECT Major, AVG(SalaryOffer)

FROM Student S, Offer O

WHERE S.SID = O.SID

GROUP BY Major;

--4)

SELECT C_Name, Interview_Time

FROM Interview I, Job J, Recruiter R, Company C

WHERE I.JobID = J.JobID AND J.RID = R.RID AND R.RID = C.CID AND Interivew_Date = '2001-12-01';

-- 5)

SELECT C_Name, AVG(BonusOffer)

FROM Offer O, Job J, Recruiter R, Company C

WHERE O.JobID = J.JobID AND J.RID = R.RID AND R.CID = C.CID;

-- 6)

SELECT JobTitle, JobDescription, JobLocation

FROM Job

WHERE JobStatus = 'Available';

-- 7)

SELECT S.SID, S_FirstName, S_Middle1, S_LastName

FROM Student S, Offer O

WHERE S.SID = O.SID

GROUP BY S.SID, S_FirstName, S_Middle1, S_LastName

HAVING COUNT(*)>1;

-- 8)

SELECT S.SID, S_FirstName, S_Middle1, S_LastName

FROM Student S

WHERE S.SID NOT IN(

SELECT O.SID

FROM Offer

);

-- 9)

SELECT JobTitle, JobDescription

FROM Job J, JobSkills JS, Skill S

WHERE S.SkillName = 'leadership'

UNION

SELECT JobTitle, JobDescription

FROM Job J, JobSkills JS, Skill S

WHERE S.SkillName = 'commnunication';

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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