sql

선택한 writer의 만화 수, 개추 평균, 최다 개추, 누적 개추

SELECT COUNT(*) 'count', AVG(recommend) AS 'avg', MAX(recommend) AS 'max', SUM(recommend) AS 'sum'
FROM cartoon
WHERE writer_id = '${id}' and writer_nickname = '${nickname}';

선택한 writer의 만화들

SELECT title, date, recommend
FROM cartoon
WHERE writer_id = '${id}' and writer_nickname = '${nickname}'
LIMIT 0, 100;

2편 이상 연재한 전채 작가들 개추 평균 or 만화 개수로 나열 ( 주석은 유동만 )

SELECT writer_nickname, COUNT(*) cnt, AVG(recommend) AS 'avg'
FROM cartoon
WHERE 1=1 /* writer_id = 'a'*/
GROUP BY writer_nickname HAVING cnt > 1
ORDER BY avg DESC /* cnt */
LIMIT 0, 100;