Commita223214

committed

add 1393

1 parent2936e19 commita223214Copy full SHA for a223214

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1105,6 +1105,7 @@ _If you like this project, please leave me a star._ ★`
`1105`	`1105`	`\|1484\|[Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)\|[Solution](../master/database/_1484.sql)\|\| Easy\|`
`1106`	`1106`	`\|1445\|[Apples & Oranges](https://leetcode.com/problems/apples-oranges/)\|[Solution](../master/database/_1445.sql)\|\| Medium\|`
`1107`	`1107`	`\|1407\|[Top Travellers](https://leetcode.com/problems/top-travellers/)\|[Solution](../master/database/_1407.sql)\|\| Easy\|`
	`1108`	`+\|1393\|[Capital Gain/Loss](https://leetcode.com/problems/capital-gainloss/)\|[Solution](../master/database/_1393.sql)\|\| Easy\|`
`1108`	`1109`	`\|1384\|[Total Sales Amount by Year](https://leetcode.com/problems/total-sales-amount-by-year/)\|[Solution](../master/database/_1384.sql)\|\| Hard\|`
`1109`	`1110`	`\|1378\|[Replace Employee ID With The Unique Identifier](https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/)\|[Solution](../master/database/_1378.sql)\|\| Easy\|`
`1110`	`1111`	`\|1369\|[Get the Second Most Recent Activity](https://leetcode.com/problems/get-the-second-most-recent-activity/)\|[Solution](../master/database/_1369.sql)\|\| Hard\|`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,6 @@`
	`1`	`+select stock_name,sum(`
	`2`	`+ case`
	`3`	`+ when operation='Buy' then-price`
	`4`	`+ else price`
	`5`	`+ end`
	`6`	`+)as capital_gain_lossfrom Stocksgroup by stock_name;`

Comments

(0)