I have two tables - Student and Interview - with values:
Students - - ------- Interview with CID name ---------- Date of CID Results = (Offer, NoForm, Horadam)
And I did not get any list of SIDs, any student has ever received a proposal, but who have more than five interviews
I am having trouble finding out that a student has more than 5 interviews Whether the cars are fixed or not. I know that you can count only records whether CID is listed more than 5 times, but I am not sure exactly how to format it. Any help would be greatly appreciated!
Use:
SELECT s. Where student is present (Selection tap - More than five interviews interviewed by i i.sid = s.sid GROUP i.sid hosting number (*)> 5) and no (selection zero) - never i.sid = Intermediation with s.sid and i.outcome = 'offers')
Comments
Post a Comment