{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":398473376,"defaultBranch":"main","name":"AdvancedSQLPuzzles","ownerLogin":"smpetersgithub","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-08-21T05:21:06.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/56611711?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1709137412.0","currentOid":""},"activityList":{"items":[{"before":"77dbfc88ef1dcb4fc6dac357a34eb6dd763ec66e","after":"f4b46914c6b3a3b13ef9b223b6b40ad8e594e064","ref":"refs/heads/main","pushedAt":"2024-07-19T17:40:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"29b1c48a19eaa9ea1368279841f95602397f43d5","after":"77dbfc88ef1dcb4fc6dac357a34eb6dd763ec66e","ref":"refs/heads/main","pushedAt":"2024-07-03T15:01:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update DeGrouping Recursion.sql","shortMessageHtmlLink":"Update DeGrouping Recursion.sql"}},{"before":"263a8c777a8eb8e295fe0f6eef7fb788ac1fd040","after":"29b1c48a19eaa9ea1368279841f95602397f43d5","ref":"refs/heads/main","pushedAt":"2024-07-03T15:01:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Associates Recursion.sql","shortMessageHtmlLink":"Update Associates Recursion.sql"}},{"before":"a69c9ef322860969f08a982b9fb89744d1b57cd7","after":"263a8c777a8eb8e295fe0f6eef7fb788ac1fd040","ref":"refs/heads/main","pushedAt":"2024-07-03T15:00:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Mandelbrot Set Recursion.sql","shortMessageHtmlLink":"Update Mandelbrot Set Recursion.sql"}},{"before":"ebfc04b59f8c609120b0c4e093f018cead11b5be","after":"a69c9ef322860969f08a982b9fb89744d1b57cd7","ref":"refs/heads/main","pushedAt":"2024-06-10T19:45:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"067688db1c4670abfe3e4f5174c2a64ebe2d39e4","after":"ebfc04b59f8c609120b0c4e093f018cead11b5be","ref":"refs/heads/main","pushedAt":"2024-06-10T19:30:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"f677acbb127aeb75feda0b6c01b8627e545355de","after":"067688db1c4670abfe3e4f5174c2a64ebe2d39e4","ref":"refs/heads/main","pushedAt":"2024-03-24T15:49:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 05 - Inner Join.md","shortMessageHtmlLink":"Update 05 - Inner Join.md"}},{"before":"4d94e3c4097ea9d516f5dd00d60ff94d03ad12fe","after":"f677acbb127aeb75feda0b6c01b8627e545355de","ref":"refs/heads/main","pushedAt":"2024-03-14T22:54:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 03 - Table Types.md","shortMessageHtmlLink":"Update 03 - Table Types.md"}},{"before":"08c767e3404fd3cb1430b351bee4e24e9df33453","after":"4d94e3c4097ea9d516f5dd00d60ff94d03ad12fe","ref":"refs/heads/main","pushedAt":"2024-03-14T20:34:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 03 - Table Types.md","shortMessageHtmlLink":"Update 03 - Table Types.md"}},{"before":"7a3af3052aeda19db7678f9fb70b6dc85f7f41fa","after":"08c767e3404fd3cb1430b351bee4e24e9df33453","ref":"refs/heads/main","pushedAt":"2024-03-04T15:30:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 04 - Equi, Theta, and Natural Joins.md","shortMessageHtmlLink":"Update 04 - Equi, Theta, and Natural Joins.md"}},{"before":"5a8a5b953dd009fe87e2541af394477589ea4883","after":"7a3af3052aeda19db7678f9fb70b6dc85f7f41fa","ref":"refs/heads/main","pushedAt":"2024-03-04T14:54:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 01 - Introduction.md","shortMessageHtmlLink":"Update 01 - Introduction.md"}},{"before":"76b47e7ef5aaf23dd989c04c37e0a0d60a565120","after":"5a8a5b953dd009fe87e2541af394477589ea4883","ref":"refs/heads/main","pushedAt":"2024-02-28T16:23:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"9468ffe02f2a51da882d502aec275de76c84d196","after":"76b47e7ef5aaf23dd989c04c37e0a0d60a565120","ref":"refs/heads/main","pushedAt":"2024-02-28T16:22:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles DDL.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles DDL.sql"}},{"before":"70aeec1c9a549a7464aa04f64c9621a69be34ad3","after":"9468ffe02f2a51da882d502aec275de76c84d196","ref":"refs/heads/main","pushedAt":"2024-02-28T16:19:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles DDL.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles DDL.sql"}},{"before":"b629f3446891d6c8366da9d69acb12ab763a3254","after":"70aeec1c9a549a7464aa04f64c9621a69be34ad3","ref":"refs/heads/main","pushedAt":"2024-02-28T16:18:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"9e30ccbf24315ce4b406c37e129561e81f6488f7","after":"b629f3446891d6c8366da9d69acb12ab763a3254","ref":"refs/heads/main","pushedAt":"2024-02-24T18:49:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"93700558714a98987d509369b2ec0e8e6d40a1c5","after":"9e30ccbf24315ce4b406c37e129561e81f6488f7","ref":"refs/heads/main","pushedAt":"2024-02-24T18:44:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"ed2bfa588c2e9fa37543a2681369096a1e17058d","after":"93700558714a98987d509369b2ec0e8e6d40a1c5","ref":"refs/heads/main","pushedAt":"2024-02-24T14:53:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles DDL.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles DDL.sql"}},{"before":"268210513e84b11988b6d0781610d2ccacf46d00","after":"ed2bfa588c2e9fa37543a2681369096a1e17058d","ref":"refs/heads/main","pushedAt":"2024-02-24T14:52:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"cb40e3925576e71f0388ab32e96ae0f99432b22c","after":"268210513e84b11988b6d0781610d2ccacf46d00","ref":"refs/heads/main","pushedAt":"2024-02-19T22:14:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"a429ca9a114e3567478d8bab91edb8dd6a5df0d5","after":"cb40e3925576e71f0388ab32e96ae0f99432b22c","ref":"refs/heads/main","pushedAt":"2024-02-19T03:46:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update 03 - Table Types.md","shortMessageHtmlLink":"Update 03 - Table Types.md"}},{"before":"5fba6b5c5526fc2a0f16aa92020dc7d617b35cae","after":"a429ca9a114e3567478d8bab91edb8dd6a5df0d5","ref":"refs/heads/main","pushedAt":"2024-02-18T18:07:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"b3431f11db9dd56d56d3bcac8374d114a0772b45","after":"5fba6b5c5526fc2a0f16aa92020dc7d617b35cae","ref":"refs/heads/main","pushedAt":"2024-02-18T18:03:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"dc333345ccf41860d54febde42f2ba7fcf6d575b","after":"b3431f11db9dd56d56d3bcac8374d114a0772b45","ref":"refs/heads/main","pushedAt":"2024-02-18T18:02:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles DDL.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles DDL.sql"}},{"before":"e912e802808144b0017ebfea68f08f1a5af43e7a","after":"dc333345ccf41860d54febde42f2ba7fcf6d575b","ref":"refs/heads/main","pushedAt":"2024-02-18T18:00:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles DDL.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles DDL.sql"}},{"before":"1a7d440cbb0c764fbd0627193c42011b431bae13","after":"e912e802808144b0017ebfea68f08f1a5af43e7a","ref":"refs/heads/main","pushedAt":"2024-02-18T17:55:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update Advanced SQL Puzzles Solutions.sql","shortMessageHtmlLink":"Update Advanced SQL Puzzles Solutions.sql"}},{"before":"0d8cdd562f223c5f4f658ac5efceebe96b34ea81","after":"1a7d440cbb0c764fbd0627193c42011b431bae13","ref":"refs/heads/main","pushedAt":"2024-02-14T21:36:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update readme.md","shortMessageHtmlLink":"Update readme.md"}},{"before":"83bfa7b3a6ff2f6ffe68dbef8c08fa404075b53e","after":"0d8cdd562f223c5f4f658ac5efceebe96b34ea81","ref":"refs/heads/main","pushedAt":"2024-02-14T21:23:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update readme.md","shortMessageHtmlLink":"Update readme.md"}},{"before":"9618b5c8e46afe0492024fcf3a3256a79414861a","after":"83bfa7b3a6ff2f6ffe68dbef8c08fa404075b53e","ref":"refs/heads/main","pushedAt":"2024-02-14T21:22:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update readme.md","shortMessageHtmlLink":"Update readme.md"}},{"before":"6c02ff5c224214f0aca560067bfdc127997d79ff","after":"9618b5c8e46afe0492024fcf3a3256a79414861a","ref":"refs/heads/main","pushedAt":"2024-02-14T21:21:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smpetersgithub","name":"Scott Peters","path":"/smpetersgithub","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/56611711?s=80&v=4"},"commit":{"message":"Update readme.md","shortMessageHtmlLink":"Update readme.md"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNy0xOVQxNzo0MDozOS4wMDAwMDBazwAAAASEJzP6","endCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wMi0xNFQyMToyMToxNy4wMDAwMDBazwAAAAP6-w7G"}},"title":"Activity · smpetersgithub/AdvancedSQLPuzzles"}