From: David Johnston <polobo@yahoo.com>
To: Andreas Kretschmer <akretschmer@spamfence.net>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: sql query problem
Date: Tue, 17 Jan 2012 09:05:44 -0500
Message-ID: <F7F2A62D-C341-4B02-9529-E48FA38843A2@yahoo.com> (raw)
In-Reply-To: <20120117133519.GA29528@tux>
References: <-926980289640737999@unknownmsgid>
<8682062e-b8fa-4778-a544-ab7671ff721b@c1g2000pbf.googlegroups.com>
<20120117133519.GA29528@tux>
On Jan 17, 2012, at 8:35, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> Alok Thakur <alokthakur1987@gmail.com> wrote:
>
>> Dear,
>>
>> I am trying to provide you as much details as possible.
>>
>> 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`)
>> )
>>
>> 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`)
>> )
>
> That's MySQL (i guess), please join a mysql-list.
>
>
DB aside the query you are looking for is very simple SQL. The only real trick is using
SUM(case when status = 1/0 then 1 else 0 end
to obtain the proper counts.
Any reference materials covering table joining and group by will give you the syntax and examples needed to write your query.
The lack of response is because most people are not going to bother answering very simple queries that beginner reference materials cover adequately. Plus, you didn't display any effort in attempting to solve the question yourself; you can do this by showing and and asking what you did wrong as opposed to simply asking for an answer.
David J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: polobo@yahoo.com, akretschmer@spamfence.net
Subject: Re: sql query problem
In-Reply-To: <F7F2A62D-C341-4B02-9529-E48FA38843A2@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox