leetcode(14)
-
[LeetCode MySQL] 183. Customers Who Never Order
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 | 3 | | 2 |..
2021.01.11 -
[LeetCode MySQL] 1179. Reformat Department Table
1179. Reformat Department Table Table: Department +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | revenue | int | | month | varchar | +---------------+---------+ (id, month) is the primary key of this table. The table has information about the revenue of each department per month. The month has values in ["Jan","Feb","Mar","Apr","May","Jun","Jul","Au..
2021.01.11