{"id":1714515,"user_name":null,"score":1,"text":"Chcesz doda\u0107 15 + 20? Jak zrobisz twoje zapytanie bez grupowania to b\u0119dziesz mia\u0142 sum\u0119 po ca\u0142o\u015bci. Mo\u017cesz te\u017c zrobi\u0107 tak \n```sql\nselect t.name, sum(enroled ) from (\nSELECT c.name, COUNT(ue.id) as enroled FROM c.course \nJOIN enroling en ON en.id_course = c.id\nJOIN user_enroled ue ON ue.enrol_id = en.id \nGROUP BY c.id, cname\n) as t\n```","edit_count":2,"is_voted":null,"is_accepted":null,"is_subscribed":null,"user_id":99030,"deleter_name":null,"delete_reason":null,"orderingScore":1,"created_at":"2020-10-14T07:51:37+02:00","updated_at":"2020-10-14T08:31:06+02:00","deleted_at":null,"user":{"id":99030,"name":"UglyMan","is_online":false,"allow_sig":1,"allow_count":1,"allow_smilies":0,"posts":2206,"visited_at":"2022-01-17T10:22:57.000000Z","created_at":"2019-03-04T13:37:58.000000Z","initials":"UM","is_verified":false,"is_deleted":true,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":"2022-01-17T10:22:57.000000Z","photo":"\/uploads\/photo\/Vsi8eCkDzVL3yX1nVOEGMOkVww5zYzrWcdwaiTkz.jpeg"},"html":"<p>Chcesz doda\u0107 15 + 20? Jak zrobisz twoje zapytanie bez grupowania to b\u0119dziesz mia\u0142 sum\u0119 po ca\u0142o\u015bci. Mo\u017cesz te\u017c zrobi\u0107 tak<\/p>\n<div class=\"markdown-code\"><div class=\"copy-button\">Kopiuj<\/div><pre><code class=\"language-sql line-numbers\">select t.name, sum(enroled ) from (\nSELECT c.name, COUNT(ue.id) as enroled FROM c.course \nJOIN enroling en ON en.id_course = c.id\nJOIN user_enroled ue ON ue.enrol_id = en.id \nGROUP BY c.id, cname\n) as t\n<\/code><\/pre><\/div>\n","url":"http:\/\/static.175.128.202.116.clients.your-server.de\/Forum\/Bazy_danych\/344909-suma_danej_kolumny?p=1714515#id1714515","is_locked":false,"editor":{"id":99030,"name":"UglyMan","is_online":false,"allow_sig":1,"allow_count":1,"allow_smilies":0,"posts":2206,"visited_at":"2022-01-17T10:22:57.000000Z","created_at":"2019-03-04T13:37:58.000000Z","initials":"UM","is_verified":false,"is_deleted":true,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":"2022-01-17T10:22:57.000000Z","photo":"\/uploads\/photo\/Vsi8eCkDzVL3yX1nVOEGMOkVww5zYzrWcdwaiTkz.jpeg"},"permissions":{"write":false,"delete":false,"update":false,"accept":false},"moderatorPermissions":{"delete":false,"update":false,"accept":false,"merge":false,"sticky":false,"admAccess":false},"comments":[],"comments_count":0,"assets":[],"metadata":"eyJpdiI6InRzbjJuLzBmZTROZm8vTXI4dG1Nc3c9PSIsInZhbHVlIjoiQ3FoelNzWUo0azZjKzRBM1FYQWVOSS83TEw3WWttSktLaTdKYnFUTFpTbm1oV2JGRVd0YnhYaXBxTDBjUklSbForN2ZzMllTOVFRVzFNWGxpSWVhcGVZengrbGdqejhqbTFDa2svVXFoYjJBV3ZHbUJHSGhFZHJ0V2NWblRtMzAiLCJtYWMiOiI1MTcyNWM5NjA3Yjk5OTk1NThjYmQzMjgwNDJlZmYwNzYxMjE2NzI4ZGNiNTMxYmYxNDFkNTFiMzgwMjRlMWQ2IiwidGFnIjoiIn0=","has_review":false,"review_style":"info","parentPostId":null,"childrenFolded":false,"type":"regular","highlighted":false}