question

LesVegetables-5424 avatar image
0 Votes"
LesVegetables-5424 asked DSPatrick answered

Query students who passed all three classes

105848-image.png



What i am trying to do is query those students who have passed all three required classes of Math (MA), English (EN), and Science (SC) with a passing grade of D or higher.

I need to query students that have taken ALL three classes of math, english, AND science in column "Course Dept" and have only grades a b c or d in the column "Grade Mark"

There is a record of the same student in different classes therefore there are duplicate student ID's for each class that they took

I have included a screen snip of the headers

not-supported
image.png (6.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Microsoft Certification Program is supported on their own forums. I'd try asking for help with exam results in dedicated forums here. (Participate\Ask A Question)
Certification Profile/Certification Dashboard
Microsoft Certification / Exams / Score Reports or Exam Results

--please don't forget to upvote and Accept as answer if the reply is helpful--



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.