Skip to content

1421. NPV Queries 👎

1
2
3
4
5
6
7
SELECT
  Queries.id,
  Queries.year,
  IFNULL(NPV.npv, 0) AS npv
FROM Queries
LEFT JOIN NPV
  USING (id, year);