FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/trips-and-users.sql at master · Monika-R/LeetCode-Solutions · GitHub
Monika-R
/
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
/
trips-and-users.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
12 lines (10 loc) · 313 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
trips-and-users.sql
Copy path
File metadata and controls
12 lines (10 loc) · 313 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
#
Time: O((t * u) + tlogt)
#
Space: O(t)
select
t
.
Request_at
Day,
round(
sum
(case when
t
.
Status
=
'
completed
'
then
0
else
1
end)
/
count
(
*
),
2
) Rate
from
Trips t
inner join
Users u
on
t
.
Client_Id
=
u
.
Users_Id
and
u
.
Banned
=
'
No
'
where
t
.
Request_at
between
'
2013-10-01
'
and
'
2013-10-03
'
group by
t
.
Request_at
Back
|
FazBrowse Home
|
New Git URL