Filtering records with conditions
This is a fixed question bank. Later sets may repeat these questions
Use this complete synthetic asset table. Filtering selects matching records without changing stored values or deleting other records
| Asset code | Copies | Loan days |
|---|---|---|
| A07 | 2 | 7 |
| B12 | 5 | 14 |
| C04 | 1 | 3 |
| D19 | 4 | 10 |
Condition: Loan days >= 14
>= means greater than or equal to
Keep a record exactly when its stated condition is true