DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Transfer-Encoding:Content-Type:Message-Id:Cc:X-Mailer:From:Subject:Date:To;
	b=11t5IdRRACgc6akkL210gyYg6o/Pcj5pGXSy2LSXblOKvGbyjx9akFIB4mMU/0zKq7IIV5r02216YY5s/USCFtiVNBmpR0eIu16f2bTy+XIdOis0A+EfQ9RVWF1oVRYCGH21/YbmXy0qru76pbjtablSOa8BKECyShZWshfiARY=
	;
References: <-926980289640737999@unknownmsgid>
	<8682062e-b8fa-4778-a544-ab7671ff721b@c1g2000pbf.googlegroups.com>
	<20120117133519.GA29528@tux>
In-Reply-To: <20120117133519.GA29528@tux>
Mime-Version: 1.0 (1.0)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <F7F2A62D-C341-4B02-9529-E48FA38843A2@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: sql query problem
Date: Tue, 17 Jan 2012 09:05:44 -0500
To: Andreas Kretschmer <akretschmer@spamfence.net>

On Jan 17, 2012, at 8:35, Andreas Kretschmer <akretschmer@spamfence.net> wro=
te:

> Alok Thakur <alokthakur1987@gmail.com> wrote:
>=20
>> Dear,
>>=20
>> I am trying to provide you as much details as possible.
>>=20
>> answer` (
>>  `id` int(10) NOT NULL AUTO_INCREMENT,
>>  `question_id` int(10) NOT NULL,
>>  `user_id` int(10) NOT NULL,
>>  `answer` int(10) NOT NULL,  ->
>>  `status` tinyint(1) NOT NULL,  --> Status will be 0 or 1 means wrong
>> or right answer
>>  `date` datetime NOT NULL,
>>  PRIMARY KEY (`quiz_result_id`)
>> )
>>=20
>> user` (
>>  `user_id` int(11) NOT NULL AUTO_INCREMENT,
>>  `user` varchar(255) NOT NULL,
>>  `username` varchar(255) NOT NULL,
>>  `user_email` varchar(255) NOT NULL,
>>  `user_gender` varchar(255) NOT NULL,
>>  `refrence` varchar(255) NOT NULL,
>>  `join_date` varchar(255) NOT NULL,
>>  `status` tinyint(1) NOT NULL,
>>  `banned` tinyint(1) NOT NULL,
>>  PRIMARY KEY (`user_id`)
>> )
>=20
> That's MySQL (i guess), please join a mysql-list.
>=20
>=20

DB aside the query you are looking for is very simple SQL.  The only real tr=
ick is using

SUM(case when status =3D 1/0 then 1 else 0 end=20

to obtain the proper counts. =20

Any reference materials covering table joining and group by will give you th=
e syntax and examples needed to write your query.

The lack of response is because most people are not going to bother answerin=
g very simple queries that beginner reference materials cover adequately.  P=
lus, you didn't display any effort in attempting to solve the question yours=
elf; you can do this by showing and and asking what you did wrong as opposed=
 to simply asking for an answer.

David J.=