Commit991bc56

committed

Update README.md

1 parentcc91e5d commit991bc56Copy full SHA for 991bc56

File tree

+17

-0

lines changed

+17

-0

lines changed

Lines changed: 17 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -515,4 +515,21 @@ FROM Accounts`
`515`	`515`	`UNION`
`516`	`516`	`SELECT'High Salary'AS category,SUM(IF(income>50000,1,0))AS accounts_count`
`517`	`517`	`FROM Accounts`
	`518`	+```
	`519`	`+`
	`520`	`+[1204. Last Person to Fit in the Bus](https://leetcode.com/problems/last-person-to-fit-in-the-bus/)`
	`521`	+```sql
	`522`	`+-- 1000 kg limit`
	`523`	`+-- name of last person`
	`524`	`+`
	`525`	`+WITH CTEAS (`
	`526`	`+SELECT person_name, weight, turn,SUM(weight)`
	`527`	`+ OVER(ORDER BY turn)AS total_weight`
	`528`	`+FROM Queue`
	`529`	`+)`
	`530`	`+SELECT person_name`
	`531`	`+FROM cte`
	`532`	`+WHERE total_weight<=1000`
	`533`	`+ORDER BY total_weightDESC`
	`534`	`+LIMIT1;`
`518`	`535`	```

Comments

(0)