leetcode

commit fc6fed6685921cedace900230d73cdd08a1ab981
parent 167ec37428ddc22e964c86d8e5926dba953b137b
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Wed, 12 Apr 2023 11:29:17 -0500

First SQL query via leet-code

Diffstat:
A
combine-two-tables/combine.sql
 | 
10
++++++++++

1 file changed, 10 insertions(+), 0 deletions(-)
diff --git a/combine-two-tables/combine.sql b/combine-two-tables/combine.sql
@@ -0,0 +1,10 @@
+-- First SQL Statement for Leet-Code
+-- Runtime: 776ms
+-- Beats: 54.92%
+
+
+
+SELECT P.firstName, P.lastName, A.city, A.state
+FROM Person AS P 
+LEFT JOIN Address as A
+ON A.personId = P.personid