{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":699418265,"defaultBranch":"main","name":"SQL-Server","ownerLogin":"ttng51","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-10-02T15:38:48.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/146753832?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1696508373.0","currentOid":""},"activityList":{"items":[{"before":"def4a5c640e6a104dfb2e0cd8dc1ff46e2c7c2c1","after":"e2b7664746f034958272d76275fe82f07c00e157","ref":"refs/heads/main","pushedAt":"2023-10-06T14:47:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update and rename SQL Solution to SQL Solutions","shortMessageHtmlLink":"Update and rename SQL Solution to SQL Solutions"}},{"before":"12fe8e163ad45baa564a72799430e92b4a3ce7fc","after":"def4a5c640e6a104dfb2e0cd8dc1ff46e2c7c2c1","ref":"refs/heads/main","pushedAt":"2023-10-06T14:45:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update SQL Solution","shortMessageHtmlLink":"Update SQL Solution"}},{"before":"cf3a65ef2c5c66f6e38165ba429dd5e903466f94","after":"12fe8e163ad45baa564a72799430e92b4a3ce7fc","ref":"refs/heads/main","pushedAt":"2023-10-06T14:43:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"96788acaf0a0f190195e5b1f63b21becdcc954e5","after":"cf3a65ef2c5c66f6e38165ba429dd5e903466f94","ref":"refs/heads/main","pushedAt":"2023-10-05T21:03:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update SQL Solution","shortMessageHtmlLink":"Update SQL Solution"}},{"before":"090a1c1c85bebc0328bf77bc0894d4606056d150","after":"96788acaf0a0f190195e5b1f63b21becdcc954e5","ref":"refs/heads/main","pushedAt":"2023-10-05T20:31:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"d98226601a437ee3f53675dd704bb35678691261","after":"090a1c1c85bebc0328bf77bc0894d4606056d150","ref":"refs/heads/main","pushedAt":"2023-10-05T20:30:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update SQL Solution","shortMessageHtmlLink":"Update SQL Solution"}},{"before":"e9568f0edcd4aefd508e024a430db7424d04719e","after":"d98226601a437ee3f53675dd704bb35678691261","ref":"refs/heads/main","pushedAt":"2023-10-05T14:02:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update SQL Solution","shortMessageHtmlLink":"Update SQL Solution"}},{"before":"5de98fbb98492fbeda95e264283768013a16618a","after":"e9568f0edcd4aefd508e024a430db7424d04719e","ref":"refs/heads/main","pushedAt":"2023-10-05T14:01:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"4493d6f6e317c1bd1e4d8969ee60c6e3b3d73a88","after":"5de98fbb98492fbeda95e264283768013a16618a","ref":"refs/heads/main","pushedAt":"2023-10-05T13:49:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"e0f4b819df39ef3a7ad02a499860a5728a4b31ee","after":"4493d6f6e317c1bd1e4d8969ee60c6e3b3d73a88","ref":"refs/heads/main","pushedAt":"2023-10-05T13:48:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update SQL Solution","shortMessageHtmlLink":"Update SQL Solution"}},{"before":"1d95fe62035d2225afc41c49deb2bbcec627a93a","after":"e0f4b819df39ef3a7ad02a499860a5728a4b31ee","ref":"refs/heads/main","pushedAt":"2023-10-05T13:47:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"a56fac6a5a0e87b3d2d4195c54ac90da4f96a6a0","after":"1d95fe62035d2225afc41c49deb2bbcec627a93a","ref":"refs/heads/main","pushedAt":"2023-10-05T13:41:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Rename Occupations Problem to SQL Solution","shortMessageHtmlLink":"Rename Occupations Problem to SQL Solution"}},{"before":"bc995ad5bc5354bdfdc7fa1d0a0ff376d025d0d9","after":"a56fac6a5a0e87b3d2d4195c54ac90da4f96a6a0","ref":"refs/heads/main","pushedAt":"2023-10-05T13:40:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Create LICENSE","shortMessageHtmlLink":"Create LICENSE"}},{"before":"32894f660b172ab043a64f9777efd6d7e48d00ee","after":"bc995ad5bc5354bdfdc7fa1d0a0ff376d025d0d9","ref":"refs/heads/main","pushedAt":"2023-10-05T13:37:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"ef3332dbe5f31207415f95ebd930042c1fc54c0e","after":"32894f660b172ab043a64f9777efd6d7e48d00ee","ref":"refs/heads/main","pushedAt":"2023-10-05T13:36:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update Occupations Problem","shortMessageHtmlLink":"Update Occupations Problem"}},{"before":"f5dfd334eb8be4a8168c8b174e0c19957ab41d02","after":"ef3332dbe5f31207415f95ebd930042c1fc54c0e","ref":"refs/heads/main","pushedAt":"2023-10-05T13:31:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"daa930b256f1bc6f5d16ff30db8a162e12d2dc9c","after":"f5dfd334eb8be4a8168c8b174e0c19957ab41d02","ref":"refs/heads/main","pushedAt":"2023-10-05T12:31:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"e25442ce61d02fb927e3a1291ee0b228c01558f6","after":"daa930b256f1bc6f5d16ff30db8a162e12d2dc9c","ref":"refs/heads/main","pushedAt":"2023-10-05T12:30:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"b8c65e33d07b11c9a3fc5cb921cb4a570fdfea7b","after":"e25442ce61d02fb927e3a1291ee0b228c01558f6","ref":"refs/heads/main","pushedAt":"2023-10-05T12:29:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"71d30bf21323914740fd57fff915cea13a74df1b","after":"b8c65e33d07b11c9a3fc5cb921cb4a570fdfea7b","ref":"refs/heads/main","pushedAt":"2023-10-05T12:28:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"08d30f68156436f85a56b685a859a72de5bae320","after":"71d30bf21323914740fd57fff915cea13a74df1b","ref":"refs/heads/main","pushedAt":"2023-10-05T12:26:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Create README.md","shortMessageHtmlLink":"Create README.md"}},{"before":"4caa10e651d01db78dc7a2748d3185d2a6c5bad1","after":"08d30f68156436f85a56b685a859a72de5bae320","ref":"refs/heads/main","pushedAt":"2023-10-05T12:20:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Update Occupations Problem","shortMessageHtmlLink":"Update Occupations Problem"}},{"before":null,"after":"4caa10e651d01db78dc7a2748d3185d2a6c5bad1","ref":"refs/heads/main","pushedAt":"2023-10-05T12:19:33.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ttng51","name":"TN","path":"/ttng51","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/146753832?s=80&v=4"},"commit":{"message":"Create Occupations Problem\n\nThe SQL query uses Common Table Expressions (CTEs) with ROW_NUMBER(). MAX() in a CASE statement to pivot these row numbers into the final table format","shortMessageHtmlLink":"Create Occupations Problem"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADkSbBRwA","startCursor":null,"endCursor":null}},"title":"Activity · ttng51/SQL-Server"}