Help is SQL query for Cursor

This translates in SQL to from a SQL select query, in incrememtal steps

1. SELECT current creditlimit and orders for all customers from TABLES customer & orders.
2. COUNT the nos of orders per customer
3. SUM the total balances of orders
4. Calculate new credit limit = Total Balance / Nos of Orders

If you know how a cursor for the PLSQL block would work for this that would be a bonus, if not just stick to the SQL query part of the problem.

I know how it works at the conceptual level but get bogged down when i try the SQL script ... am working alone so in need of some support.

yours fustrated,
Charlie

charlie_at_rahinston.com

Data Below:

CREATE TABLE customer (

	custnumb  NUMBER(8)			NOT NULL,
	custname  VARCHAR2(25),
	custaddr 	VARCHAR2(30),
	balance 	decimal(6,2),
	credlim 	NUMBER(4),
	slsrnumb 	NUMBER(4) 		REFERENCES slsrep(slsrnumb),
	
		PRIMARY KEY(custnumb));
		

• 3) Create Table for Orders CREATE TABLE orders (

	ordnumb	NUMBER(8), 
	orddte  DATE,
	custnumb NUMBER(8) 			REFERENCES customer(custnumb),
 
 		PRIMARY KEY(ordnumb));