Commitfa3337e

committed

add 1661

1 parentc7ff64d commitfa3337eCopy full SHA for fa3337e

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1077,6 +1077,7 @@ _If you like this project, please leave me a star._ ★`
`1077`	`1077`	`\|1683\|[Invalid Tweets](https://leetcode.com/problems/invalid-tweets/)\|[Solution](../master/database/_1683.sql)\|\| Easy\|`
`1078`	`1078`	`\|1677\|[Product's Worth Over Invoices](https://leetcode.com/problems/products-worth-over-invoices/)\|[Solution](../master/database/_1677.sql)\|\| Easy\|`
`1079`	`1079`	`\|1667\|[Fix Names in a Table](https://leetcode.com/problems/fix-names-in-a-table/)\|[Solution](../master/database/_1667.sql)\|\| Easy\|`
	`1080`	`+\|1661\|[Average Time of Process per Machine](https://leetcode.com/problems/average-time-of-process-per-machine/)\|[Solution](../master/database/_1661.sql)\|\| Easy\|`
`1080`	`1081`	`\|1607\|[Sellers With No Sales](https://leetcode.com/problems/sellers-with-no-sales/)\|[Solution](../master/database/_1607.sql)\|\| Easy\|`
`1081`	`1082`	`\|1581\|[Customer Who Visited but Did Not Make Any Transactions](https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/)\|[Solution](../master/database/_1581.sql)\|\| Easy\|`
`1082`	`1083`	`\|1543\|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)\|[Solution](../master/database/_1543.sql)\|\| Easy\|`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+selects.machine_id, round(avg(e.timestamp-s.timestamp),3)as processing_time`
	`2`	`+from Activity sjoin Activity e`
	`3`	`+ons.machine_id=e.machine_idands.process_id=e.process_idands.activity_type='start'ande.activity_type='end'group bys.machine_id;`

Comments

(0)