목록left join (1)

HAZEL

[SQL : Leetcode] LEFT JOIN 문

1. 183. Customers Who Never Order >> 문제 Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything. Table: Customers. +----+-------+ | Id | Name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Table: Orders. +----+------------+ | Id | CustomerId | +----+------------+ | 1 ..
DATA ANALYSIS/SQL 2021. 2. 13. 00:31
이전 Prev 1 Next 다음