Message-ID: <4D07B415.1090108@gmail.com>
Date: Tue, 14 Dec 2010 11:14:45 -0700
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.15) Gecko/20101026 SUSE/3.0.10 Lightning/1.0b1
	Thunderbird/3.0.10
MIME-Version: 1.0
To: emaratiyya <emaratiyya@hotmail.com>
CC: pgsql-sql@postgresql.org
References: <AANLkTinYNWi1AQft188MBWj4n6OBfSQX1DdAO2Jf8wQu@mail.gmail.com>
	<1292311156150-3304147.post@n5.nabble.com>
	<4D0799F7.9050206@gmail.com>
In-Reply-To: <4D0799F7.9050206@gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Subject: Re: Using count on a join, group by required?

If you showed your work, you might get decent hints if not solutions.

On 12/14/2010 09:23 AM, Rob Sargent wrote:
> Shouldn't you be doing your own homework?
> 
> emaratiyya wrote:
>> Hi,Please help me solving this problem. I appreciate..Thankyou.
>>
>> Create the following table and insert few arbitrary records. Product
>> (product_id, product_name, supplier_name, quantity, price_per_unit)
>> You are required to create PL/SQL package that achieves the following
>> functionalities:
>>
>> •    Obtaining the product supplier name by using the product_id
>> •    Changing the price_per_unit by using the product_id
>> •    When changing the price of the product, you have to have PL/SQL
>> code that
>> keeps the history of the prices. For this functionality you need to
>> create
>> audit table: product_audit(product_id, old_price, new_price,
>> date_of_change)
>> •    Updating the quantity by using the product_id
>> •    Get warning when the product level of stock (quantity) goes below
>> certain
>> threshold (e.g. 10)
>>
>>