Leetcode Problem 1421. NPV Queries

1421. NPV Queries

Leetcode Solutions

JOIN with Default Value Replacement

Algorithm

Perform a LEFT JOIN between the Queries table and the NPV table on the id and year columns.
Use the COALESCE function to replace any NULL values in the npv column with 0.
Select the id, year, and the result of the COALESCE function as the npv in the final result set.


erDiagram
    NPV {
        int id
        int year
        int npv
        id year {label:"PK"}
    }
    Queries {
        int id
        int year
        id year {label:"PK"}
    }

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...