# Searching the Evidence Logs

THE CHRISTMAS HEIST! · challenge 5 · medium

> Detective Quacker's phone rings. "Librarian Lucy here! I heard about the thefts and Coach Waddles' suspicious GPS patterns. I've digitized years of delivery activity descriptions from the warehouse archives. Something doesn't add up - search through the activity_description field for any mention of 'anonymous' OR 'secret'. These keywords might reveal hidden charitable activities or coded criminal messages. How many suspicious activity records contain these words?"

## Task

Count how many activity records contain the word "anonymous" OR "secret" in their descriptions. You will be working with the `delivery_activities` table.

## Tables

### `delivery_activities` (2500 rows)

| column | type |
| --- | --- |
| activity_id | INTEGER |
| delivery_id | INTEGER |
| activity_description | VARCHAR |
| activity_time | TIMESTAMP |
| district | VARCHAR |
| notes | VARCHAR |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/christmas_local.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/christmas_local.duckdb' AS db (READ_ONLY);
USE db;
```

Play it in the browser: https://dbquacks.com/challenges/christmas/5

## Answer

The expected answer is not published. Submit on the page to have it checked.