|
|
Posted by Hugo Kornelis on 10/09/06 22:26
On 9 Oct 2006 08:37:38 -0700, jacquescallaghan@gmail.com wrote:
>Hello guys, I urgently need to get the these queries. I tried REALLY
>hard to solve them but unfortunately couldn't figure it out and I am
>running out of deadline. PLEASE help.
Hi Jacques,
This really sounds like a homework/class assignment. I don't usually
answer those, but you sound so ndesperate that I'll make an exception.
First - since you already tried hard to solve them, why not post what
you already have. I'm sure that you've already created some tables and
populated them with some test data. Please post the CREATE TABLE and
INSERT statements that allow us to recreate your test data.
You've probably also already written some queries for the various
questions. Even though they don't work, you can help us help you by
posting them here and indicating how the output they produce is
incorrect.
>(a) Answer the following queries using SQL:
>(i) Find the projects for which maximum number of writers has written
>the items.
>(ii) Find the item writer details whose software items have the maximum
>average number
> of bugs.
>(iii) Find the average number of bugs for each software project.
>(iv) List the projects in the order of number of items in that project.
Some hints to put you on the right track: These tasks all require the
use of aggregate function. Most also require one or more subqueries.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|