FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/market-analysis-i.sql at master · feiyunwill/LeetCode-Solutions · GitHub
feiyunwill
/
LeetCode-Solutions
Public
forked from
kamyu104/LeetCode-Solutions
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
market-analysis-i.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
13 lines (12 loc) · 454 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
market-analysis-i.sql
Copy path
File metadata and controls
13 lines (12 loc) · 454 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
#
Time: O(m + n)
#
Space: O(m + n)
SELECT
u
.
user_id
AS
buyer_id,
u
.
join_date
,
Ifnull(
t
.
orders_in_2019
,
0
)
AS
orders_in_2019
FROM
users u
LEFT JOIN
(
SELECT
buyer_id
AS
user_id,
Count
(buyer_id)
AS
orders_in_2019
FROM
orders
WHERE
Year(order_date)
=
2019
GROUP BY buyer_id)t
ON
u
.
user_id
=
t
.
user_id
Back
|
FazBrowse Home
|
New Git URL