{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":698706970,"defaultBranch":"main","name":"SQL-Data-Analysis-and-Visualization-Projects","ownerLogin":"Serjiklis","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-09-30T18:00:57.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/71043316?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1696096857.0","currentOid":""},"activityList":{"items":[{"before":"cf414f5e36ee37fbd1d11b164feb0c2078c8ff41","after":"e0806660aa8e11735bd4b79a28c18e326a6890a3","ref":"refs/heads/main","pushedAt":"2023-10-14T17:57:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"add description","shortMessageHtmlLink":"add description"}},{"before":"edd6eaeeb5f691c88a90c444a9ae47b574f9db8c","after":"cf414f5e36ee37fbd1d11b164feb0c2078c8ff41","ref":"refs/heads/main","pushedAt":"2023-10-13T19:42:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Delete Boot Camp/Project SQL Data Exploration/Dataset/owid-covid-data.csv","shortMessageHtmlLink":"Delete Boot Camp/Project SQL Data Exploration/Dataset/owid-covid-data…"}},{"before":"b7bfbf1f2e3415d7cfcdd3f7b6c9c6b5a291d858","after":"edd6eaeeb5f691c88a90c444a9ae47b574f9db8c","ref":"refs/heads/main","pushedAt":"2023-10-13T19:42:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Delete Boot Camp/Project SQL Data Exploration/Dataset/CovidVactinations.csv","shortMessageHtmlLink":"Delete Boot Camp/Project SQL Data Exploration/Dataset/CovidVactinatio…"}},{"before":"3870ba9f9e3b8600de5212cdd271ad9bb0bd308e","after":"b7bfbf1f2e3415d7cfcdd3f7b6c9c6b5a291d858","ref":"refs/heads/main","pushedAt":"2023-10-13T19:41:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"add description","shortMessageHtmlLink":"add description"}},{"before":"24edaed66ae07d659e1f17c1ec924365619dc601","after":"3870ba9f9e3b8600de5212cdd271ad9bb0bd308e","ref":"refs/heads/main","pushedAt":"2023-10-13T19:12:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"add comments","shortMessageHtmlLink":"add comments"}},{"before":"3d8474846204a508a238b6e7f8387bd98dcc9fcc","after":"24edaed66ae07d659e1f17c1ec924365619dc601","ref":"refs/heads/main","pushedAt":"2023-10-13T15:29:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"SQL Data Cleaning Project","shortMessageHtmlLink":"SQL Data Cleaning Project"}},{"before":"32e7d3b1301f24774842eb0149d8cc80df3b18d3","after":"3d8474846204a508a238b6e7f8387bd98dcc9fcc","ref":"refs/heads/main","pushedAt":"2023-10-12T15:50:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Create Views","shortMessageHtmlLink":"Create Views"}},{"before":"db11cde061a7f0da68cb2ee5f3ff8a8b5fb1c94d","after":"32e7d3b1301f24774842eb0149d8cc80df3b18d3","ref":"refs/heads/main","pushedAt":"2023-10-12T15:20:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Project - Data Exploration","shortMessageHtmlLink":"Project - Data Exploration"}},{"before":"88ee3c4c5d5b874044b26767f6e6e47764ac497f","after":"db11cde061a7f0da68cb2ee5f3ff8a8b5fb1c94d","ref":"refs/heads/main","pushedAt":"2023-10-11T15:36:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Subqueries","shortMessageHtmlLink":"Subqueries"}},{"before":"b9baba458f51ef0e27e602cab3203e6f4aed8402","after":"88ee3c4c5d5b874044b26767f6e6e47764ac497f","ref":"refs/heads/main","pushedAt":"2023-10-11T13:51:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Stored Procedures","shortMessageHtmlLink":"Stored Procedures"}},{"before":"819c22eee60465eb174fbaab9a0593acd3076589","after":"b9baba458f51ef0e27e602cab3203e6f4aed8402","ref":"refs/heads/main","pushedAt":"2023-10-11T12:52:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"String Functions - TRIM, LTRIM, RTRIM, Replace, Substring, Upper, Lower","shortMessageHtmlLink":"String Functions - TRIM, LTRIM, RTRIM, Replace, Substring, Upper, Lower"}},{"before":"06813198e2e9ed5c6ad1b1da142fe49a3f0fb44c","after":"819c22eee60465eb174fbaab9a0593acd3076589","ref":"refs/heads/main","pushedAt":"2023-10-11T11:34:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Temp Tables","shortMessageHtmlLink":"Temp Tables"}},{"before":"401cd52104eaf2452b77af40fb10f7fb3b7326e7","after":"06813198e2e9ed5c6ad1b1da142fe49a3f0fb44c","ref":"refs/heads/main","pushedAt":"2023-10-11T09:52:08.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Merge remote-tracking branch 'origin/main'","shortMessageHtmlLink":"Merge remote-tracking branch 'origin/main'"}},{"before":"713532e953091f48770fb558ae0fbc89b1521c47","after":"401cd52104eaf2452b77af40fb10f7fb3b7326e7","ref":"refs/heads/main","pushedAt":"2023-10-04T19:49:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update Update_and_delete_data.md","shortMessageHtmlLink":"Update Update_and_delete_data.md"}},{"before":"31cc6653f7c4e948faaa23d94642a968988c12ca","after":"713532e953091f48770fb558ae0fbc89b1521c47","ref":"refs/heads/main","pushedAt":"2023-10-04T19:47:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update Update_and_delete_data.md","shortMessageHtmlLink":"Update Update_and_delete_data.md"}},{"before":"ae28393f4198d28e7df6ab49d07f16474b3e042b","after":"31cc6653f7c4e948faaa23d94642a968988c12ca","ref":"refs/heads/main","pushedAt":"2023-10-04T19:46:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update Update_and_delete_data.md","shortMessageHtmlLink":"Update Update_and_delete_data.md"}},{"before":"1859b8b50cf8c0a64f72ee29e1d19ed9f538eb93","after":"ae28393f4198d28e7df6ab49d07f16474b3e042b","ref":"refs/heads/main","pushedAt":"2023-10-04T19:44:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update Update_and_delete_data.md","shortMessageHtmlLink":"Update Update_and_delete_data.md"}},{"before":"2786dbe616586512ee3f5a58eb12fa9324a560f0","after":"1859b8b50cf8c0a64f72ee29e1d19ed9f538eb93","ref":"refs/heads/main","pushedAt":"2023-10-04T19:41:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"update and delete","shortMessageHtmlLink":"update and delete"}},{"before":"196e9983abbf1c95a22ebf49dc9f24884967cf19","after":"2786dbe616586512ee3f5a58eb12fa9324a560f0","ref":"refs/heads/main","pushedAt":"2023-10-04T07:37:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"update and delete theory","shortMessageHtmlLink":"update and delete theory"}},{"before":"a96a7715adb7872374ffbace232796dbeb3f87bc","after":"196e9983abbf1c95a22ebf49dc9f24884967cf19","ref":"refs/heads/main","pushedAt":"2023-10-04T07:18:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"having clause","shortMessageHtmlLink":"having clause"}},{"before":"151b450bba4f95ebdb827b3665e95b4ad23b58b1","after":"a96a7715adb7872374ffbace232796dbeb3f87bc","ref":"refs/heads/main","pushedAt":"2023-10-02T15:01:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"case statement","shortMessageHtmlLink":"case statement"}},{"before":"48f48495a777136bb968e6f64df6a74e1796a8c5","after":"151b450bba4f95ebdb827b3665e95b4ad23b58b1","ref":"refs/heads/main","pushedAt":"2023-10-01T20:23:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"unions","shortMessageHtmlLink":"unions"}},{"before":"b38593f74a139a03479804c84600fe7062beeb48","after":"48f48495a777136bb968e6f64df6a74e1796a8c5","ref":"refs/heads/main","pushedAt":"2023-10-01T13:55:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"joins","shortMessageHtmlLink":"joins"}},{"before":"3e5cb1d0cd629e2639e404ead6a216b8290a78ff","after":"b38593f74a139a03479804c84600fe7062beeb48","ref":"refs/heads/main","pushedAt":"2023-09-30T21:39:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Group By and Order By","shortMessageHtmlLink":"Group By and Order By"}},{"before":"56a19f603dca2f1ce14cac31a75164d7c6340da6","after":"3e5cb1d0cd629e2639e404ead6a216b8290a78ff","ref":"refs/heads/main","pushedAt":"2023-09-30T20:35:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Fix Where Statement","shortMessageHtmlLink":"Fix Where Statement"}},{"before":"6bea4a429150b9aefe8d5646ebce4da020301b76","after":"56a19f603dca2f1ce14cac31a75164d7c6340da6","ref":"refs/heads/main","pushedAt":"2023-09-30T20:27:14.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Merge remote-tracking branch 'origin/main'","shortMessageHtmlLink":"Merge remote-tracking branch 'origin/main'"}},{"before":"38e33f120899814d2166e34f6840b9df64aa302a","after":"6bea4a429150b9aefe8d5646ebce4da020301b76","ref":"refs/heads/main","pushedAt":"2023-09-30T19:07:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"af3f4ceafc3611296395180bb4ca8dc430f6e677","after":"38e33f120899814d2166e34f6840b9df64aa302a","ref":"refs/heads/main","pushedAt":"2023-09-30T19:06:58.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"create table","shortMessageHtmlLink":"create table"}},{"before":"c9b63379b37cafbeaf2806bb3da37373865de63d","after":"af3f4ceafc3611296395180bb4ca8dc430f6e677","ref":"refs/heads/main","pushedAt":"2023-09-30T18:31:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"9f4e8092b5c1b374fd81e7942b18f61eb4ea2068","after":"c9b63379b37cafbeaf2806bb3da37373865de63d","ref":"refs/heads/main","pushedAt":"2023-09-30T18:28:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Serjiklis","name":"SerhiiM","path":"/Serjiklis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/71043316?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,"cursor":"Y3Vyc29yOnYyOpK7MjAyMy0xMC0xNFQxNzo1NzozOC4wMDAwMDBazwAAAAOXFW_l","startCursor":"Y3Vyc29yOnYyOpK7MjAyMy0xMC0xNFQxNzo1NzozOC4wMDAwMDBazwAAAAOXFW_l","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0zMFQxODoyODo1OC4wMDAwMDBazwAAAAOMg588"}},"title":"Activity · Serjiklis/SQL-Data-Analysis-and-Visualization-Projects"}