FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/ads-performance.sql at master · HappyCoderGit/LeetCode-Solutions · GitHub
HappyCoderGit
/
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
/
ads-performance.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
23 lines (21 loc) · 505 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
ads-performance.sql
Copy path
File metadata and controls
23 lines (21 loc) · 505 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
14
15
16
17
18
19
20
21
22
23
#
Time: O(nlogn)
#
Space: O(n)
SELECT
ad_id,
CASE
WHEN clicks
+
views
=
0
THEN
0
ELSE ROUND(
100
*
clicks
/
(clicks
+
views),
2
)
END ctr
FROM
(
SELECT
ad_id,
SUM
(CASE
WHEN action
=
'
Viewed
'
THEN
1
ELSE
0
END) views,
SUM
(CASE
WHEN action
=
'
Clicked
'
THEN
1
ELSE
0
END) clicks
FROM
Ads
GROUP BY
ad_id) a
ORDER BY
ctr
DESC
,
ad_id
ASC
Back
|
FazBrowse Home
|
New Git URL