Leetcode 175. Combine Two Tables in Python | Python Leetcode | Python Coding Tutorial | Python ASMR

Leetcode 175. Combine Two Tables in Python | Python Leetcode | Python Coding Tutorial | Python ASMR

Table: Person
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| personId | int |
| lastName | varchar |
| firstName | varchar |
+-------------+---------+
personId is the primary key (column with unique values) for this table.
This table contains information about the ID of some persons and their first and last names.

Table: Address
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| addressId | int |
| personId | int |
| city | varchar |
| state | varchar |
+-------------+---------+
addressId is the primary key (column with unique values) for this table.
Each row of this table contains information about the city and state of one person with ID = PersonId.

Write a solution to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead.
Return the result table in any order.
The result format is in the following example.

Example 1:
Input:
Person table:
+----------+----------+-----------+
| personId | lastName | firstName |
+----------+----------+-----------+
| 1 | Wang | Allen |
| 2 | Alice | Bob |
+----------+----------+-----------+
Address table:
+-----------+----------+---------------+------------+
| addressId | personId | city | state |
+-----------+----------+---------------+------------+
| 1 | 2 | New York City | New York |
| 2 | 3 | Leetcode | California |
+-----------+----------+---------------+------------+
Output:
+-----------+----------+---------------+----------+
| firstName | lastName | city | state |
+-----------+----------+---------------+----------+
| Allen | Wang | Null | Null |
| Bob | Alice | New York City | New York |
+-----------+----------+---------------+----------+
Explanation:
There is no address in the address table for the personId = 1 so we return null in their city and state.

Please don’t forget to Like ,Comment and Share the Videos!
Each and every Like , Comment and Share helps us!

Thanks for Watching🙏😍😘

Please Subscribe to watch more videos.

In case of any copyrighted Content, Please reach out to us.

* Hope you like it

📷 Welcome to Code is Art! 👨‍💻

🔗 Follow us on social media:

Join our coding community and follow us on Instagram for coding inspiration 🎨, GitHub for code collaboration 🐙, Twitter for coding updates 🐤, Reddit for coding discussions 🤖, Facebook for coding news 📚, YouTube for coding tutorials 🎬, and Discord to connect with fellow coders and share your experiences 🎧. Let's grow our coding skills together! #CodeIsArt #FollowUsNow 👨‍💻💻🐤📱📚🎬🎧

#leetcodecombinetwotables #leetcodecombinetwotablesalgorithm #leetcodecombinetwotablesexample #leetcodecombinetwotablesinpython #python #leetcode #leetcodeinpython #asmr #asmrcoding #asmrprogramming #howtolearncodingforbeginners #learntocode2025 #howtolearntocode #learnpythonprogramming2025 #pythontutorial #howtolearncoding #howtocodeleetcodecombinetwotablesinpython #howtostartcodingforbeginners #learncodingforbeginners #learnpythonprogrammingforbeginners #datascienceinterviewquestions #faangcodinginterviewpreparation #faangpreparation #placementscodingpreparation #interviewcodingquestionsandanswers