| clause | Description |
|---|---|
| tape = 'CD0003' | Show all files on tape CD0003 |
| runno > 550 and runno < 600 | Show runs between 550 and 600 |
| start_date = '02-Jun-1998' and start_time > '16:00:00' and start_time < '21:00:00' | Show runs started on 2 June 1998 between 4 PM and 9 PM |