8000 Update README.md · Learner457/sql-50-leetcode@74db512 · GitHub
[go: up one dir, main page]

Skip to content

Commit 74db512

Browse files
authored
Update README.md
1 parent 45b2974 commit 74db512

File tree

1 file changed

+2
-0
lines changed

1 file changed

+2
-0
lines changed

README.md

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -95,6 +95,8 @@ WHERE
9595

9696
[1661 - Average Time of Process per Machine](https://leetcode.com/problems/average-time-of-process-per-machine/)
9797
```sql
98+
99+
-- 1ST approach is by writing subquery to make temporary table first and then we apply math function
98100
SELECT machine_id, ROUND(AVG(end - start), 3) AS processing_time
99101
FROM
100102
(SELECT machine_id, process_id,

0 commit comments

Comments
 (0)
0