{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":713826891,"defaultBranch":"main","name":"Necessary-SQL","ownerLogin":"mijanr","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-11-03T10:13:22.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/13090001?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1703802965.0","currentOid":""},"activityList":{"items":[{"before":"e48a410553bc37c1138e58b2a8a66af3d1b3f14f","after":"0116b2ca7624c1326d40df2e8487980bd9ea18f4","ref":"refs/heads/main","pushedAt":"2024-04-08T13:51:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"4ac821055e7daadecc7fbc64684ebd452ffff8c0","after":"e48a410553bc37c1138e58b2a8a66af3d1b3f14f","ref":"refs/heads/main","pushedAt":"2024-04-08T13:49:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Create .gitattributes","shortMessageHtmlLink":"Create .gitattributes"}},{"before":"aef12c3d2910244af6b164e9ff5a65d7b705c193","after":"6b1594fa481e43fcb361388359a0be426cd30127","ref":"refs/heads/duckdb","pushedAt":"2023-12-28T22:37:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"initial commit","shortMessageHtmlLink":"initial commit"}},{"before":null,"after":"aef12c3d2910244af6b164e9ff5a65d7b705c193","ref":"refs/heads/duckdb","pushedAt":"2023-12-28T22:36:05.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Merge pull request #4 from mijanr/3-add-requirementsyaml-file\n\n3 add requirements.yml file","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2010986528\" data-permission-text=\"Title is private\" data-url=\"https://github.com/mijanr/Necessary-SQL/issues/4\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/mijanr/Necessary-SQL/pull/4/hovercard\" href=\"https://github.com/mijanr/Necessary-SQL/pull/4\">#4</a> from mijanr/3-add-requirementsyaml-file"}},{"before":"aef12c3d2910244af6b164e9ff5a65d7b705c193","after":"4ac821055e7daadecc7fbc64684ebd452ffff8c0","ref":"refs/heads/main","pushedAt":"2023-12-07T10:02:33.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Merge pull request #5 from mijanr/interview_questions\n\nInterview questions","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2030364492\" data-permission-text=\"Title is private\" data-url=\"https://github.com/mijanr/Necessary-SQL/issues/5\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/mijanr/Necessary-SQL/pull/5/hovercard\" href=\"https://github.com/mijanr/Necessary-SQL/pull/5\">#5</a> from mijanr/interview_questions"}},{"before":"22e5536b84da0cb1c2d8e1ff31553c7d1b5d0e57","after":"6d9d06ff51f7bb4ac78cef52bac8c7dc77435545","ref":"refs/heads/interview_questions","pushedAt":"2023-12-07T09:59:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"references added","shortMessageHtmlLink":"references added"}},{"before":"aef12c3d2910244af6b164e9ff5a65d7b705c193","after":"22e5536b84da0cb1c2d8e1ff31553c7d1b5d0e57","ref":"refs/heads/interview_questions","pushedAt":"2023-12-07T09:57:58.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"demo to primary and foreign keys added","shortMessageHtmlLink":"demo to primary and foreign keys added"}},{"before":null,"after":"aef12c3d2910244af6b164e9ff5a65d7b705c193","ref":"refs/heads/interview_questions","pushedAt":"2023-12-07T08:59:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Merge pull request #4 from mijanr/3-add-requirementsyaml-file\n\n3 add requirements.yml file","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2010986528\" data-permission-text=\"Title is private\" data-url=\"https://github.com/mijanr/Necessary-SQL/issues/4\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/mijanr/Necessary-SQL/pull/4/hovercard\" href=\"https://github.com/mijanr/Necessary-SQL/pull/4\">#4</a> from mijanr/3-add-requirementsyaml-file"}},{"before":"e15c1b6db078c0600c737c98438f0d2daa02469a","after":null,"ref":"refs/heads/2-move-ipynb-files-to-a-notebook-folder-perhaps","pushedAt":"2023-11-26T14:42:56.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"}},{"before":"40a58550bd8bbec5d197565af866463e9b063220","after":"5fbcdac29e1924c8318b6f91d4f8c961d64d51d3","ref":"refs/heads/1-add-dockerfile","pushedAt":"2023-11-26T13:06:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"latest ubuntu image pulled","shortMessageHtmlLink":"latest ubuntu image pulled"}},{"before":"71c33a3373bd63f339c1250423ad24becdb8895a","after":"40a58550bd8bbec5d197565af866463e9b063220","ref":"refs/heads/1-add-dockerfile","pushedAt":"2023-11-26T11:28:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"dockerfile added","shortMessageHtmlLink":"dockerfile added"}},{"before":"aef12c3d2910244af6b164e9ff5a65d7b705c193","after":"71c33a3373bd63f339c1250423ad24becdb8895a","ref":"refs/heads/1-add-dockerfile","pushedAt":"2023-11-26T11:04:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"initial commit","shortMessageHtmlLink":"initial commit"}},{"before":null,"after":"aef12c3d2910244af6b164e9ff5a65d7b705c193","ref":"refs/heads/1-add-dockerfile","pushedAt":"2023-11-26T10:58:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Merge pull request #4 from mijanr/3-add-requirementsyaml-file\n\n3 add requirements.yml file","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2010986528\" data-permission-text=\"Title is private\" data-url=\"https://github.com/mijanr/Necessary-SQL/issues/4\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/mijanr/Necessary-SQL/pull/4/hovercard\" href=\"https://github.com/mijanr/Necessary-SQL/pull/4\">#4</a> from mijanr/3-add-requirementsyaml-file"}},{"before":"98e34260169ee7d45ba4c0ba47a973f85dbb68a4","after":null,"ref":"refs/heads/3-add-requirementsyaml-file","pushedAt":"2023-11-26T10:33:14.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"}},{"before":"e15c1b6db078c0600c737c98438f0d2daa02469a","after":"aef12c3d2910244af6b164e9ff5a65d7b705c193","ref":"refs/heads/main","pushedAt":"2023-11-26T10:33:03.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"Merge pull request #4 from mijanr/3-add-requirementsyaml-file\n\n3 add requirements.yml file","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2010986528\" data-permission-text=\"Title is private\" data-url=\"https://github.com/mijanr/Necessary-SQL/issues/4\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/mijanr/Necessary-SQL/pull/4/hovercard\" href=\"https://github.com/mijanr/Necessary-SQL/pull/4\">#4</a> from mijanr/3-add-requirementsyaml-file"}},{"before":"e15c1b6db078c0600c737c98438f0d2daa02469a","after":"98e34260169ee7d45ba4c0ba47a973f85dbb68a4","ref":"refs/heads/3-add-requirementsyaml-file","pushedAt":"2023-11-26T10:31:52.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"readme updated","shortMessageHtmlLink":"readme updated"}},{"before":null,"after":"e15c1b6db078c0600c737c98438f0d2daa02469a","ref":"refs/heads/3-add-requirementsyaml-file","pushedAt":"2023-11-26T10:22:58.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"files moved to notebooks directory","shortMessageHtmlLink":"files moved to notebooks directory"}},{"before":"2658d4abfba40e56c96af072cb56d2db2411592c","after":"e15c1b6db078c0600c737c98438f0d2daa02469a","ref":"refs/heads/main","pushedAt":"2023-11-26T10:06:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"files moved to notebooks directory","shortMessageHtmlLink":"files moved to notebooks directory"}},{"before":"2658d4abfba40e56c96af072cb56d2db2411592c","after":"e15c1b6db078c0600c737c98438f0d2daa02469a","ref":"refs/heads/2-move-ipynb-files-to-a-notebook-folder-perhaps","pushedAt":"2023-11-26T10:04:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"files moved to notebooks directory","shortMessageHtmlLink":"files moved to notebooks directory"}},{"before":null,"after":"2658d4abfba40e56c96af072cb56d2db2411592c","ref":"refs/heads/2-move-ipynb-files-to-a-notebook-folder-perhaps","pushedAt":"2023-11-26T10:03:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"MIN LICENSE added","shortMessageHtmlLink":"MIN LICENSE added"}},{"before":"8a8cdabf24a2af1bce40d6e122ab7f9d7e11d8ac","after":"2658d4abfba40e56c96af072cb56d2db2411592c","ref":"refs/heads/main","pushedAt":"2023-11-26T09:55:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"MIN LICENSE added","shortMessageHtmlLink":"MIN LICENSE added"}},{"before":"8e0e58c6721596fc802fee46c4b20f293c392b82","after":"8a8cdabf24a2af1bce40d6e122ab7f9d7e11d8ac","ref":"refs/heads/main","pushedAt":"2023-11-07T18:49:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"SQL joins diagram added","shortMessageHtmlLink":"SQL joins diagram added"}},{"before":"197b43a0df9987cbe8528279784f71fae97301dc","after":"8e0e58c6721596fc802fee46c4b20f293c392b82","ref":"refs/heads/main","pushedAt":"2023-11-04T08:49:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"plots updated","shortMessageHtmlLink":"plots updated"}},{"before":"131838b25136942cf6bc7448df6f058e711597a6","after":"197b43a0df9987cbe8528279784f71fae97301dc","ref":"refs/heads/main","pushedAt":"2023-11-04T08:38:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"IN NOT EXISTS for tables added","shortMessageHtmlLink":"IN NOT EXISTS for tables added"}},{"before":"fbd50b0795fafe28c720b7d32bd820cf15ec61ff","after":"131838b25136942cf6bc7448df6f058e711597a6","ref":"refs/heads/main","pushedAt":"2023-11-03T23:22:50.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"find top 5 customers by total sales added","shortMessageHtmlLink":"find top 5 customers by total sales added"}},{"before":"be2e966cf84297da8ce3452c2b6cd830ee5a9297","after":"fbd50b0795fafe28c720b7d32bd820cf15ec61ff","ref":"refs/heads/main","pushedAt":"2023-11-03T22:20:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"WINDOW functions, LEAD, LAG, rounding, random samples, manipulating dates and text added","shortMessageHtmlLink":"WINDOW functions, LEAD, LAG, rounding, random samples, manipulating d…"}},{"before":"527c0803cc898ea426f7d754e1907f09488ec854","after":"be2e966cf84297da8ce3452c2b6cd830ee5a9297","ref":"refs/heads/main","pushedAt":"2023-11-03T21:10:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"schema name corrected","shortMessageHtmlLink":"schema name corrected"}},{"before":"a721b4d103a455b195a03695c29c4ed1395f6d69","after":"527c0803cc898ea426f7d754e1907f09488ec854","ref":"refs/heads/main","pushedAt":"2023-11-03T16:58:57.000Z","pushType":"push","commitsCount":7,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"difference between CTE and temporary tables added","shortMessageHtmlLink":"difference between CTE and temporary tables added"}},{"before":"2ef2f2254004b33b8d36f89abcc606eb352c92e6","after":"a721b4d103a455b195a03695c29c4ed1395f6d69","ref":"refs/heads/main","pushedAt":"2023-11-03T16:39:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"unnecessary cells deleted","shortMessageHtmlLink":"unnecessary cells deleted"}},{"before":"4c8cddd6d6b6d354f51f257166fd2c60a964a97f","after":"2ef2f2254004b33b8d36f89abcc606eb352c92e6","ref":"refs/heads/main","pushedAt":"2023-11-03T16:36:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mijanr","name":"Md Mijanur Rahman","path":"/mijanr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13090001?s=80&v=4"},"commit":{"message":"different type of joins added","shortMessageHtmlLink":"different type of joins added"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEKv0BgAA","startCursor":null,"endCursor":null}},"title":"Activity · mijanr/Necessary-SQL"}