SkyWave 2: Trifecta Challenge

Overview

The "SkyWave 2: Trifecta" challenge, created by syyntax, requires participants to determine how many devices in the database are categorized as either a smartphone, computer, or tablet. This challenge tests your ability to join tables and filter data based on specific conditions.

Challenge Details

Points: 15
Creator: syyntax
Objective: Count the number of devices that are either a smartphone, computer, or tablet in the database.
Submission Format: flag{number}

Provided Information

Database Access: Continue using the same SSH connection from the previous challenge (High Tower).

Username: skywave

Password: d34df4c3

Solution Process

SQL Query Breakdown

To find the number of devices in the database that are smartphones, computers, or tablets, we used the following SQL query:

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');

The SQL query joins the Devices and Device_Types tables based on the device_type_id, then filters the results for devices categorized as smartphone, computer, or tablet.

Result

The query returned 714 devices matching the criteria.

Flag

The flag is: flag{714}