add 1421

fishercoder1534 · fishercoder1534 · commit 67e048b6dc3b · 2024-01-29T17:46:56.000-08:00
diff --git a/database/_1421.sql b/database/_1421.sql
@@ -0,0 +1,2 @@
+-- # Write your MySQL query statement below
+select q.id, q.year, ifnull(n.npv, 0) as npv from Queries as q left join NPV as n on q.id = n.id and q.year = n.year

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- # Write your MySQL query statement below`
	`2`	`+select q.id, q.year, ifnull(n.npv, 0) as npv from Queries as q left join NPV as n on q.id = n.id and q.year = n.year`