Home -> Usenet -> comp.databases.oracle -> SQL subquery question

SQL subquery question

From: Trent Sams <trentsams_at_email.com>
Date: 17 Apr 2003 14:06:14 -0700
Message-ID: <c19d9e50.0304171306.2b451e2_at_posting.google.com> 






Hi,



I'm trying to analyze the data in a table and the SQL to do this is
way over my head.  The table includes columns:



cust_id

order_type ('I' or 'R')
order_date
order_id




init_order_id (null or an order_id)


product_id


qty



The order_type column identifies if this is the initial order for this
customer for this product or a reorder.  If the order is a reorder
then the init_order_id column is populated with the order_id of the
initial order.



Ultimately, I'd like to know by product_id

  count of customers have order_type = 'I', sum(qty)
  count of customers have order_type = 'R', sum(qty)
  count of customers have order_type = 'I' and no order_type = 'R',


sum(qty)



Can someone get me started in the right direction?
TIA!!

Received on Thu Apr 17 2003 - 23:06:14 CEST












Original text of this message