SKYWAVE 2: TRIFECTA

Overview

“SkyWave 2: Trifecta” by syyntax asks for a count of devices whose type is smartphone, computer, or tablet. Use a simple join and an IN filter.

Provided Access
SSH ssh skywave@skywave.deadface.io
User skywave
Pass d34df4c3

Continue from High Tower session.

SQL — count device types via join
SELECT COUNT(*)
FROM Devices d
JOIN Device_Types dt ON d.device_type_id = dt.device_type_id
WHERE dt.device_type_name IN ('smartphone', 'computer', 'tablet');
Result

The query returns a total of 714 matching devices.

Flag
flag{714}
> Back to DEADFACE > Explore Blogs