Kinoco Hacker Hands-on security practice
All challenges In progress
General Skills Level 3 100 points

SQL Query Master - Complex Joins

Mission

SQLite database /app/company.db has 3 tables: - employees (id, name, department_id, salary) - departments (id, name, manager_id) - projects (id, name, department_id, budget) Create a query that finds: 1. Departments with projects having budget >= 100000 2. Highest paid employee in those departments 3. That person's name and email address (email column) The email contains a hint for the flag.

#sql#database#sqlite#joins

Clear it in 3 steps

Not started

  1. Start the environment

  2. Investigate the target

    Available after the environment starts

  3. Submit the flag