Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 109889F9947 for ; Sun, 7 Oct 2007 16:25:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75348-04 for ; Sun, 7 Oct 2007 16:25:14 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 9A6689F98DF for ; Sun, 7 Oct 2007 16:25:13 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id l97JP4kt002692 for ; Sun, 7 Oct 2007 16:25:04 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id l97JG8dl097919 for pgsql-sql@postgresql.org; Sun, 7 Oct 2007 16:16:08 -0300 (ADT) (envelope-from news) From: =?iso-8859-1?q?Rodrigo_De_Le=F3n?= X-Newsgroups: pgsql.sql Subject: Re: SQL query question Date: Sun, 07 Oct 2007 19:16:16 -0000 Organization: http://groups.google.com Lines: 11 Message-ID: <1191784576.250021.263080@50g2000hsm.googlegroups.com> References: <1190351385.027308.79280@t8g2000prg.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Complaints-To: groups-abuse@google.com In-Reply-To: <1190351385.027308.79280@t8g2000prg.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: 50g2000hsm.googlegroups.com; posting-host=201.224.11.33; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/36 X-Sequence-Number: 29408 On Sep 21, 12:09 am, stevenleong...@gmail.com wrote: > Write the query (or queries if necessary) needed to count the number > of employees in each employee's department who are paid more than > their manager. SELECT e.dept, COALESCE (SUM (1), 0) AS n FROM employees e JOIN employees m ON (e.empid = m.mgrid AND e.salary > m.salary) GROUP BY e.dept ORDER BY e.dept