Can I use Google Visualization API Query Language to replace if and filter functions?

Question

I have the following formula that works to do the following (Shown in the first screen shot):

• check for the same student ID number on the English tab and find a match on the Transcript with Credits tab..
• Once it finds the matching student ID number it then checks to see if the students has taken the English class listed on row 1 of the English tab by checking column D on the Transcript with Credits tab.
• If the student has taken the class it returns an "x" on the English tab to indicate the student has completed that class.
• Here is the formula that works: =iferror(if(filter('Transcript with Credits'!$D:$D, ('Transcript with Credits'!$A:$A=$A2)*('Transcript with Credits'!$D:$D=E$1))=E$1, "X", ""))

English Tab

Transcript with Credits Tab

I am wondering if this can be done using a query instead. I tried the following but it didn't work: =QUERY({A:A, 'Transcript with Credits'!A:D}, "Select 'Transcript with Credits'!D Where $A:$A = 'Transcript with Credits'!$A:$A and 'Transcript with Credits'!$D:$D = '"&E2&"'")