You can specify two conditions on the same row of an example table. For example, to display every clerk in Department 20, the following query is the same as connecting the two conditions by AND.
Q.STAFF | ID | NAME | DEPT | JOB | --------+----+------+------+-------| P. | | | 20 | CLERK | |