|---| -----| --------| ----------|

|1|[Two Sum](https://leetcode.com/problems/two-sum/)|[JavaScript](./src/two-sum/res.js)|Easy|

|2|[Add Two Numbers](https://leetcode.com/problems/add-two-numbers/)|[JavaScript](./src/add-two-numbers/res.js)|Medium|

|175|[Combine Two Tables](https://leetcode.com/problems/combine-two-tables/)|[SQL](./src/combine-two-tables/res.txt)|Easy|

|181|[Employees Earning More Than Their Managers](https://leetcode.com/problems/employees-earning-more-than-their-managers/)|[SQL](./src/employees-earning-more-than-their-managers/res.txt)|Easy|

|434|[Number of Segments in a String](https://leetcode.com/problems/number-of-segments-in-a-string/)|[JavaScript](./src/number-of-segments-in-a-string/res.js)|Easy|

-- Table: Person

-- +-------------+---------+

-- | Column Name | Type |

-- +-------------+---------+

-- | PersonId | int |

-- | FirstName | varchar |

-- | LastName | varchar |

-- +-------------+---------+

-- PersonId is the primary key column for this table.

-- Table: Address

-- +-------------+---------+

-- | Column Name | Type |

-- +-------------+---------+

-- | AddressId | int |

-- | PersonId | int |

-- | City | varchar |

-- | State | varchar |

-- +-------------+---------+

-- AddressId is the primary key column for this table.

-- Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:

-- FirstName, LastName, City, State

# Write your MySQL query statement below

SELECT a.FirstName, a.LastName, b.City, b.State from Person a left join Address b ON a.PersonId = b.PersonId;