기존학습자료/leetcode, hackerrank

Leetcode 175 - Combine Two Tables

gooreumsea 2023. 6. 24. 19:46

Combine Two Tables
https://leetcode.com/problems/Combine-Two-Tables/

SELECT firstName, lastName, city, state             
FROM Person
     LEFT JOIN Address ON Person.personId =Address.personId
     
    
    
# {"headers": 

# ["firstName", "lastName", "city", "state"], 

# "values": 

# [["Allen", "Wang", null, null], 
# ["Bob", "Alice", "New York City", "New York"]]}