Learn the SQL WHERE Clause: THE CIPHER

THE CIPHER is chapter 2 and the first mission built on the SQL WHERE clause. The DEAD_DROPS table tracks each site's CODENAME, CITY, STATUS, and LAST_SERVICE date. You filter for active sites, exclude burned ones with not-equal comparisons, and combine conditions with AND for a night operation in Prague.

A second operation hands you the INTERCEPTED_SIGNALS table from NSA listening posts. Hostile operators hide the word ECHO inside their callsigns, so exact matches stop working. You switch to LIKE with the % and _ wildcards to hunt patterns instead of values.

Both missions run in your browser against live tables, free, with no signup.

This is the shape of query you practice here, not the answer to any mission. The real stages come with their own data, objectives, and hints.

SELECT *
FROM DEAD_DROPS
WHERE CITY = 'VIENNA' AND STATUS = 'ACTIVE';