Advertisement
nocturnalmk

Untitled

Aug 5th, 2014
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.29 KB | None | 0 0
  1.                         SELECT concat(YEAR, '-', lpad(MONTH, 2, '0')) AS MONTH,
  2.                                COUNT(id) AS COUNT
  3.                         FROM
  4.                           (SELECT id,
  5.                                   email,
  6.                                   EXTRACT(MONTH FROM joined) AS MONTH,
  7.                                   EXTRACT(YEAR FROM joined) AS YEAR
  8.                            FROM
  9.                              (SELECT id,
  10.                                      email,
  11.                                      MIN("from") AS joined
  12.                               FROM
  13.                                 (SELECT members."id",
  14.                                         members."email",
  15.                                         fees."from",
  16.                                         fees. "to"
  17.                                  FROM members,
  18.                                       fees
  19.                                  WHERE members.id = member_id
  20.                                    AND fees."from" BETWEEN ? AND ?) tbl
  21.                               GROUP BY id) AS tbl2) tbl3
  22.                         GROUP BY concat(MONTH, YEAR);
  23.  
  24.  
  25. # ERROR:  COLUMN "tbl.email" must appear IN the GROUP BY clause OR be used IN an aggregate FUNCTION
  26. # LINE 12:              email,
  27. #                       ^
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement