SkyWave 1: High Tower Challenge

Overview

The "SkyWave 1: High Tower" challenge, created by syyntax, requires the participant to identify the tower_id of a cell tower with a specific elevation using SQL queries. This challenge tests basic SQL knowledge and data filtering techniques.

Challenge Details

Points: 5
Creator: syyntax
Objective: Use SQL commands to find the tower_id for the tower that sits at an approximate elevation of 220 ft.
Submission Format: flag{tower_id}

Provided Information

Database Access: ssh skywave@skywave.deadface.io

Username: skywave

Password: d34df4c3

Solution Process

Step-by-Step Query Process

The goal is to find the tower with an elevation close to 220 feet. The steps to solve the challenge were:

1. Connect to the SQL database via SSH:
ssh skywave@skywave.deadface.io

2. List all the tables in the database:
SHOW TABLES;

3. Describe the structure of the Towers table to understand its columns:
DESCRIBE Towers;

4. Query the tower with an elevation close to 220 feet:
SELECT tower_id FROM Towers WHERE elevation BETWEEN 219.5 AND 220.5;

Identified Tower ID

Based on the SQL query result, the tower_id with the specified elevation was 215.

Flag

The flag is: flag{215}