Commite1100dc

committed

add 1623

1 parent8a73f70 commite1100dcCopy full SHA for e1100dc

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1080,6 +1080,7 @@ _If you like this project, please leave me a star._ ★`
`1080`	`1080`	`\|1667\|[Fix Names in a Table](https://leetcode.com/problems/fix-names-in-a-table/)\|[Solution](../master/database/_1667.sql)\|\| Easy\|`
`1081`	`1081`	`\|1661\|[Average Time of Process per Machine](https://leetcode.com/problems/average-time-of-process-per-machine/)\|[Solution](../master/database/_1661.sql)\|\| Easy\|`
`1082`	`1082`	`\|1633\|[Percentage of Users Attended a Contest](https://leetcode.com/problems/percentage-of-users-attended-a-contest/)\|[Solution](../master/database/_1633.sql)\|\| Easy\|`
	`1083`	`+\|1623\|[All Valid Triplets That Can Represent a Country](https://leetcode.com/problems/all-valid-triplets-that-can-represent-a-country/)\|[Solution](../master/database/_1623.sql)\|\| Easy\|`
`1083`	`1084`	`\|1607\|[Sellers With No Sales](https://leetcode.com/problems/sellers-with-no-sales/)\|[Solution](../master/database/_1607.sql)\|\| Easy\|`
`1084`	`1085`	`\|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\|`
`1085`	`1086`	`\|1543\|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)\|[Solution](../master/database/_1543.sql)\|\| Easy\|`

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,10 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+selecta.student_nameas member_A,`
	`3`	`+b.student_nameas member_B,`
	`4`	`+c.student_nameas member_C`
	`5`	`+from SchoolA across join SchoolB bcross join SchoolC cwherea.student_name!=b.student_nameand`
	`6`	`+a.student_id!=b.student_idand`
	`7`	`+b.student_name!=c.student_nameand`
	`8`	`+b.student_id!=c.student_idand`
	`9`	`+a.student_name!=c.student_nameand`
	`10`	`+a.student_id!=c.student_id;`

Comments

(0)