{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":745328808,"defaultBranch":"main","name":"SQL","ownerLogin":"seunghyeon98","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-01-19T05:10:09.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/111716640?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1705661530.0","currentOid":""},"activityList":{"items":[{"before":"93fc59076836aaa8949b29ec20098e33ea715374","after":"56235b0c7aeb8207213cf47b9d88f39705e2412a","ref":"refs/heads/main","pushedAt":"2024-03-27T01:26:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0327'","shortMessageHtmlLink":"'TIL_0327'"}},{"before":"58a106f5091ce63fd1a0441056bb394cf888b9a0","after":"93fc59076836aaa8949b29ec20098e33ea715374","ref":"refs/heads/main","pushedAt":"2024-03-26T01:48:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0326","shortMessageHtmlLink":"TIL_0326"}},{"before":"f977304b586b97ec5ea66a4e46e7a9c08d15e9b3","after":"58a106f5091ce63fd1a0441056bb394cf888b9a0","ref":"refs/heads/main","pushedAt":"2024-03-25T02:03:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0325","shortMessageHtmlLink":"TIL_0325"}},{"before":"60a47474fb870ad966b1b1ad446e6bba549cb874","after":"f977304b586b97ec5ea66a4e46e7a9c08d15e9b3","ref":"refs/heads/main","pushedAt":"2024-03-24T05:33:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0324","shortMessageHtmlLink":"TIL_0324"}},{"before":"7077eddc2c73e85b41603fe8c70b3bd86d151769","after":"60a47474fb870ad966b1b1ad446e6bba549cb874","ref":"refs/heads/main","pushedAt":"2024-03-23T08:46:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0323\nLesson\n[leetcode]\n1907\n- sum(조건식)을 통한 집계\nsum함수내에 조건식을 사용하면, 조건을 만족하는 row는1, 아니면 0이\n반환된다. 이때 값이 1인값만 sum되므로, 조건을 만족하는 row의 갯수를 구할\n수 있게되는 것이다.\n- 각 카테고리의 값이 필수로 존재해야한다면, 각 카테고리 조건에 맞게 각각\n  집계하고, union을 통해 테이블을 합쳐야한다.\n\n1204\n- sum(weight) over(order by Turn) as totalweight -> over절을 통해\n  각행별로 sum집계하기","shortMessageHtmlLink":"TIL_0323"}},{"before":"f4d9fbfc2d78c5dd36528c1ea54aea79dea1214e","after":"7077eddc2c73e85b41603fe8c70b3bd86d151769","ref":"refs/heads/main","pushedAt":"2024-03-22T10:53:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0322'","shortMessageHtmlLink":"'TIL_0322'"}},{"before":"c27a0f584123b848b43338f36a32c857d4be0900","after":"f4d9fbfc2d78c5dd36528c1ea54aea79dea1214e","ref":"refs/heads/main","pushedAt":"2024-03-21T02:26:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0312","shortMessageHtmlLink":"TIL_0312"}},{"before":"2c36b6b74414b56444a5db42b63f78b7c6f2d77d","after":"c27a0f584123b848b43338f36a32c857d4be0900","ref":"refs/heads/main","pushedAt":"2024-03-20T05:34:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0320","shortMessageHtmlLink":"TIL_0320"}},{"before":"c37b9eeaa997fcb30bb3736367226c467f1842c8","after":"2c36b6b74414b56444a5db42b63f78b7c6f2d77d","ref":"refs/heads/main","pushedAt":"2024-03-19T09:27:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0319","shortMessageHtmlLink":"TIL_0319"}},{"before":"2e1d74d6efa1208fce70ce0d99ef2a523fcb647c","after":"c37b9eeaa997fcb30bb3736367226c467f1842c8","ref":"refs/heads/main","pushedAt":"2024-03-18T04:06:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0318'","shortMessageHtmlLink":"'TIL_0318'"}},{"before":"6f0bdac090d338eb59f1169f7016e969b80ea40b","after":"2e1d74d6efa1208fce70ce0d99ef2a523fcb647c","ref":"refs/heads/main","pushedAt":"2024-03-15T02:31:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0315","shortMessageHtmlLink":"TIL_0315"}},{"before":"4b52bc06da407384473f97f2f242840df6b95c92","after":"6f0bdac090d338eb59f1169f7016e969b80ea40b","ref":"refs/heads/main","pushedAt":"2024-03-14T03:49:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0314","shortMessageHtmlLink":"TIL_0314"}},{"before":"f57ef4f4c4cef6c360e44b05b8dcd327927a4177","after":"4b52bc06da407384473f97f2f242840df6b95c92","ref":"refs/heads/main","pushedAt":"2024-03-13T06:06:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0313","shortMessageHtmlLink":"TIL_0313"}},{"before":"630dd25808b05562c7bc427e6947aeb461ec343a","after":"f57ef4f4c4cef6c360e44b05b8dcd327927a4177","ref":"refs/heads/main","pushedAt":"2024-03-12T12:44:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0312","shortMessageHtmlLink":"TIL_0312"}},{"before":"c3278c33d537b50fdbee28396d702003ecd6faab","after":"630dd25808b05562c7bc427e6947aeb461ec343a","ref":"refs/heads/main","pushedAt":"2024-03-11T04:04:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0311","shortMessageHtmlLink":"TIL_0311"}},{"before":"0c35b4f27ee9df66eedbe22869575b2bafd0fd8a","after":"c3278c33d537b50fdbee28396d702003ecd6faab","ref":"refs/heads/main","pushedAt":"2024-03-10T04:32:02.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0310","shortMessageHtmlLink":"TIL_0310"}},{"before":"901db918618ca1a2f4e16e0b2fadfa674da36292","after":"0c35b4f27ee9df66eedbe22869575b2bafd0fd8a","ref":"refs/heads/main","pushedAt":"2024-03-09T02:06:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0309","shortMessageHtmlLink":"TIL_0309"}},{"before":"d7c5f0f598c43c87876099a05758179b62cfe40f","after":"901db918618ca1a2f4e16e0b2fadfa674da36292","ref":"refs/heads/main","pushedAt":"2024-03-08T04:27:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0308","shortMessageHtmlLink":"TIL_0308"}},{"before":"41473adb9606fe6624035e8f754fdb932bb1934e","after":"d7c5f0f598c43c87876099a05758179b62cfe40f","ref":"refs/heads/main","pushedAt":"2024-03-07T04:33:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"fec276c5879897a55a6b98a516088dfc104aa269","after":"41473adb9606fe6624035e8f754fdb932bb1934e","ref":"refs/heads/main","pushedAt":"2024-03-07T04:20:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0307","shortMessageHtmlLink":"TIL_0307"}},{"before":"44734a9bfcb36ab458f79c653dd144024b8d2a2b","after":"fec276c5879897a55a6b98a516088dfc104aa269","ref":"refs/heads/main","pushedAt":"2024-03-06T07:55:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0306'","shortMessageHtmlLink":"'TIL_0306'"}},{"before":"b601f2fb0e82b1e5ace2cfb51b303cc8495554ea","after":"44734a9bfcb36ab458f79c653dd144024b8d2a2b","ref":"refs/heads/main","pushedAt":"2024-03-05T11:01:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"TIL_0305","shortMessageHtmlLink":"TIL_0305"}},{"before":"1ef2f06afb856627955a9e3bad0c29312f1bf1df","after":"b601f2fb0e82b1e5ace2cfb51b303cc8495554ea","ref":"refs/heads/main","pushedAt":"2024-03-04T05:51:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0304'","shortMessageHtmlLink":"'TIL_0304'"}},{"before":"44e8089d00fd8a548ccefb15348e91d90cb66a8e","after":"1ef2f06afb856627955a9e3bad0c29312f1bf1df","ref":"refs/heads/main","pushedAt":"2024-02-29T09:16:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0228'","shortMessageHtmlLink":"'TIL_0228'"}},{"before":"f6d83b154c1b90fced87b9d735af3b7390525c0b","after":"44e8089d00fd8a548ccefb15348e91d90cb66a8e","ref":"refs/heads/main","pushedAt":"2024-02-19T13:53:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"solved1070","shortMessageHtmlLink":"solved1070"}},{"before":"0056d2d13136cd9f6fc66752b00cbde849eea721","after":"f6d83b154c1b90fced87b9d735af3b7390525c0b","ref":"refs/heads/main","pushedAt":"2024-02-18T08:33:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'TIL_0218'","shortMessageHtmlLink":"'TIL_0218'"}},{"before":"9d3f93423a64fbac4d3759404a52f4d982d0cc22","after":"0056d2d13136cd9f6fc66752b00cbde849eea721","ref":"refs/heads/main","pushedAt":"2024-01-24T13:16:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"[TIL] solve testdome sql problem\n- +4","shortMessageHtmlLink":"[TIL] solve testdome sql problem"}},{"before":"56110bc268e10229cfa9827be6357726e7376f37","after":"9d3f93423a64fbac4d3759404a52f4d982d0cc22","ref":"refs/heads/main","pushedAt":"2024-01-22T13:35:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"[TIL] solve leetcode sql problem\n- sorting and grouping +2\n- advanced select and joins +1\n- basic agg functions +2\n- etc..","shortMessageHtmlLink":"[TIL] solve leetcode sql problem"}},{"before":"019f85d4281948da3727d762c0b5c234d20e2a7f","after":"56110bc268e10229cfa9827be6357726e7376f37","ref":"refs/heads/main","pushedAt":"2024-01-19T10:53:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"'620'","shortMessageHtmlLink":"'620'"}},{"before":null,"after":"019f85d4281948da3727d762c0b5c234d20e2a7f","ref":"refs/heads/main","pushedAt":"2024-01-19T10:52:10.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"seunghyeon98","name":"Havi","path":"/seunghyeon98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/111716640?s=80&v=4"},"commit":{"message":"first commit","shortMessageHtmlLink":"first commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wMy0yN1QwMToyNjoxMS4wMDAwMDBazwAAAAQgN6Kw","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wMy0yN1QwMToyNjoxMS4wMDAwMDBazwAAAAQgN6Kw","endCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wMS0xOVQxMDo1MjoxMC4wMDAwMDBazwAAAAPj5DmD"}},"title":"Activity · seunghyeon98/SQL"}