Re: Simple Query, complicated user.



Your best bet would be to make multiple queries. Make one for Math
with grade A, Science with grade A, and Computers with grade A. Now
make a query that joins the Math query with the Science query on
Student ID. Your results will be all students that took both Math and
Science and received an A in both. Do the same with Math and
Computers.

You can do the same for your second problem, except this time join your
queries on SemesterID. The results should give you the number of
Semesters where students took Math and Science or Math and Computers
and received an A in both.

Hope that helps!

.



Relevant Pages

  • Re: Harvard Pres: Women Lack Ability In Math, Sciences
    ... to the fact that women have a right to learn science if they choose to do so. ... men in math and science has ... posts so that this doesn't turn into a 1200 line rantfest. ... > school boys than girls tend to score at very high and very low levels on ...
    (sci.geo.geology)
  • MORE OF THE SAME BAD IDEAS DEMOCRATS HAVE INNOVATIVE AGENDA?
    ... MORE OF THE SAME BAD IDEAS DEMOCRATS HAVE 'INNOVATIVE AGENDA?' ... salaries of math and science teachers. ... approach to education? ...
    (alt.politics.bush)
  • Re: Why Men Are Better Than Women in Science and Math
    ... >that could help account for the persistent paucity of women in science ... While average verbal scores are very similar, boys have outscored ... >subcategory of math to the next. ... Japanese girls, for example, were on ...
    (sci.med)
  • Re: How many dimensions are there?
    ... Miguel Rios wrote: ... about how these things in science are done. ... one of the greatest math theories that have ever ... to represent the correct physics. ...
    (sci.physics.relativity)
  • Re: Harvard Pres: Women Lack Ability In Math, Sciences
    ... Apparently George wants to post his response to me in a group that I have ... My reasoning is that science is about the pursuit of the truth. ... >> victims are men. ... standardized math tests, and that it was important to consider the ...
    (sci.geo.geology)