1421. NPV Queries

https://leetcode.com/problems/npv-queries/

Account Login - LeetCode

select b.id, b.year, IFNULL(a.npv, 0) as npv
from NPV as a
right outer join Queries as b
on a.id = b.id and a.year = b.year