• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo's Developer Journal Thomas Ngo's Developer Journal
  • Home
  • Journal
  • Tags
  • About
    Thomas Ngo

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Project Employees I

    February 10, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query

    Problem

    problem-1075

    Query

    SELECT
        p.project_id,
        ROUND(AVG(e.experience_years), 2) AS average_years
    FROM
        Project AS p
    JOIN
        Employee AS e
        ON
            p.employee_id = e.employee_id
    GROUP BY
        p.project_id
    

    Tags: SQL

    Updated: February 10, 2024

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Problem of The Day: Maximize the Number of Target Nodes After Connecting Trees II

    May 28, 2025 1 minute read

    Problem Statement

    Problem of The Day: Set Matrix Zeroes

    May 27, 2025 1 minute read

    Problem Statement

    Problem of The Day: Set Matrix Zeroes

    May 20, 2025 1 minute read

    Problem Statement

    Problem of The Day: Simplify Path

    May 19, 2025 less than 1 minute read

    Problem Statement

    • Follow:
    • GitHub
    • LinkedIn
    © 2025 Thomas Ngo.