{"action":"opened","issue":{"url":"https://api.github.com/repos/opencloset/opencloset/issues/1114","repository_url":"https://api.github.com/repos/opencloset/opencloset","labels_url":"https://api.github.com/repos/opencloset/opencloset/issues/1114/labels{/name}","comments_url":"https://api.github.com/repos/opencloset/opencloset/issues/1114/comments","events_url":"https://api.github.com/repos/opencloset/opencloset/issues/1114/events","html_url":"https://github.com/opencloset/opencloset/issues/1114","id":197659334,"number":1114,"title":"옷캔, 비백 카테고리별 의류 수량","user":{"login":"aanoaa","id":170528,"avatar_url":"https://avatars.githubusercontent.com/u/170528?v=3","gravatar_id":"","url":"https://api.github.com/users/aanoaa","html_url":"https://github.com/aanoaa","followers_url":"https://api.github.com/users/aanoaa/followers","following_url":"https://api.github.com/users/aanoaa/following{/other_user}","gists_url":"https://api.github.com/users/aanoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/aanoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aanoaa/subscriptions","organizations_url":"https://api.github.com/users/aanoaa/orgs","repos_url":"https://api.github.com/users/aanoaa/repos","events_url":"https://api.github.com/users/aanoaa/events{/privacy}","received_events_url":"https://api.github.com/users/aanoaa/received_events","type":"User","site_admin":false},"labels":[{"id":161735917,"url":"https://api.github.com/repos/opencloset/opencloset/labels/%ED%86%B5%EA%B3%84","name":"통계","color":"009800","default":false}],"state":"open","locked":false,"assignee":{"login":"aanoaa","id":170528,"avatar_url":"https://avatars.githubusercontent.com/u/170528?v=3","gravatar_id":"","url":"https://api.github.com/users/aanoaa","html_url":"https://github.com/aanoaa","followers_url":"https://api.github.com/users/aanoaa/followers","following_url":"https://api.github.com/users/aanoaa/following{/other_user}","gists_url":"https://api.github.com/users/aanoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/aanoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aanoaa/subscriptions","organizations_url":"https://api.github.com/users/aanoaa/orgs","repos_url":"https://api.github.com/users/aanoaa/repos","events_url":"https://api.github.com/users/aanoaa/events{/privacy}","received_events_url":"https://api.github.com/users/aanoaa/received_events","type":"User","site_admin":false},"assignees":[{"login":"aanoaa","id":170528,"avatar_url":"https://avatars.githubusercontent.com/u/170528?v=3","gravatar_id":"","url":"https://api.github.com/users/aanoaa","html_url":"https://github.com/aanoaa","followers_url":"https://api.github.com/users/aanoaa/followers","following_url":"https://api.github.com/users/aanoaa/following{/other_user}","gists_url":"https://api.github.com/users/aanoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/aanoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aanoaa/subscriptions","organizations_url":"https://api.github.com/users/aanoaa/orgs","repos_url":"https://api.github.com/users/aanoaa/repos","events_url":"https://api.github.com/users/aanoaa/events{/privacy}","received_events_url":"https://api.github.com/users/aanoaa/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-12-27T07:20:58Z","updated_at":"2016-12-27T07:20:58Z","closed_at":null,"body":"``` sql\r\nSELECT c.category, COUNT(*) FROM clothes c JOIN status s ON c.status_id = s.id WHERE c.status_id = 45 GROUP BY c.category; -- 45: 옷캔, 46: 비백\r\n```\r\n\r\n옷캔\r\n\r\n```\r\n+-----------+----------+\r\n| category  | COUNT(*) |\r\n+-----------+----------+\r\n| belt      |       22 |\r\n| blouse    |      413 |\r\n| coat      |      128 |\r\n| jacket    |     1307 |\r\n| misc      |      277 |\r\n| onepiece  |      163 |\r\n| pants     |     1317 |\r\n| shirt     |      570 |\r\n| shoes     |      203 |\r\n| skirt     |      411 |\r\n| tie       |      820 |\r\n| waistcoat |       53 |\r\n+-----------+----------+\r\n```\r\n\r\n비백\r\n\r\n```\r\n+-----------+----------+\r\n| category  | COUNT(*) |\r\n+-----------+----------+\r\n| jacket    |       87 |\r\n| onepiece  |        1 |\r\n| pants     |       81 |\r\n| shirt     |        4 |\r\n| skirt     |        7 |\r\n| tie       |      130 |\r\n| waistcoat |        2 |\r\n+-----------+----------+\r\n```\r\n"}}
{"actor":{"display_login":"aanoaa"}}