Im between cherry

Leet Code | MySQL | 183. Customers Who Never Order 본문

데이터분석/practice_query

Leet Code | MySQL | 183. Customers Who Never Order

meal 2020. 8. 30. 15:39

183. Customers Who Never Order

https://leetcode.com/problems/customers-who-never-order/

 

Customers Who Never Order - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

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.

 

SELECT c.Name AS Customers
FROM Customers As c
    LEFT JOIN Orders As o ON c.id = o.Customerid
WHERE o.id IS NULL

 

저작자표시

'데이터분석 > practice_query' 카테고리의 다른 글

Programmers | MySQL | 모든 레코드 조회하기  (0) 2020.08.30
Leet Code | MySQL | 1179. Reformat Department Table  (0) 2020.08.30
Leet Code | MySQL | 197. Rising Temperature  (0) 2020.08.30
Leet Code | MySQL | 185. Department Top Three Salaries  (0) 2020.08.30
Leet Code | MySQL | 184. Department Highest Salary  (0) 2020.08.30
'데이터분석/practice_query' Related Articles more
Comments