1421. NPV Queries

자료구조 알고리즘/코딩테스트

내공얌냠 2022. 6. 24. 21:06

Account Login - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

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

728x90