 |
Example - Creating a Query (3 of 3) |   |
Software - Databases
|
| We want to find out which girls had exam marks over 70% in Physics. So we need to tell the database we are interested only in students
who are girls - in the Sex field we add 'F'.
We need to tell the field 'Physics' to
display exam results better than 70%, and then we have to
display the highest exam results first: |
