Quick Overview

Write a SQL query that finds every village tied for the most total funding in calendar year 2024, then every top-funded project within each winning village. Preserve ties at both levels, aggregate multiple fund rows, use an exact year boundary, and order results deterministically.

Find Top-Funded Villages and Their Top Projects

Company: Adobe

Role: Software Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Online Assessment

Overview: Write a SQL query that finds every village tied for the most total funding in calendar year 2024, then every top-funded project within each winning village. Preserve ties at both levels, aggregate multiple fund rows, use an exact year boundary, and order results deterministically.

Loading…