Re: Challenging SQL request - Donovan Walker - com.mysql.lists.java

5 messages in com.mysql.lists.javaRe: Challenging SQL request

From	Sent On	Attachments
Donovan Walker	23 Jul 2002 02:34
Zart Colwing	23 Jul 2002 02:36
Zart Colwing	23 Jul 2002 04:29
Arthur Fuller	24 Jul 2002 05:05
Jeff Kilbride	25 Jul 2002 09:13

Subject:	Re: Challenging SQL request
From:	Donovan Walker (kz...@user1.inficad.com)
Date:	07/23/2002 02:34:21 AM
List:	com.mysql.lists.java

That should be pretty easy....

The first part of the query returns all clients who have orders between the 2 dates, from that subset return only the clients who have more than 3 rows.... if you if you could give me the schema, i could write it out for you....

Thanks,

Donovan

On Tue, 23 Jul 2002, Zart Colwing wrote:

Hi,

I've been ask once to write a SQL request that fulfill the following requirement, but as I miserably failed I'm asking the list for some help - it won't help my case, but it will enlighten me !

The requirement: "Write the SQL request that returns the clients who have more than 3 orders between two dates." The database schema was not given but I can infer that we have an academically organized database with at least a "client" table with an "id" and "name" column and a "order" table with a "date" and "client_id" columns.

-----

Your suggestions are very much welcomed.

ZartC

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.