SQL Challenges · THE CHRISTMAS HEIST!
Searching the Evidence Logs
Difficulty: medium
Detective Quackers phone rings. Librarian Lucy here! I heard about the thefts and Coach Waddles suspicious GPS patterns. Ive digitized years of delivery activity descriptions from the warehouse archives. Something doesnt 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?
Your task
Count how many activity records contain the word "anonymous" OR "secret" in their descriptions. You will be working with the `delivery_activities` table.