Dividing a count by another count
Hi everyone, I'm working on a library database, and I need to find the average amount of books borrowed by the customers. I'm trying to do something like :
count(AMOUNT OF BOOKS LOANS) divided by count (AMOUNT OF CUSTOMERS )
I know I could simply
SELECT (AMOUNT OF BOOK LOANS ) DIV ( AMOUNT OF CUSTOMERS)
but i need to write it in one query, can someone help me ?
Subject
Written By
Posted
Dividing a count by another count
August 31, 2020 06:27PM
September 01, 2020 04:27AM
September 01, 2020 12:48PM
September 01, 2020 03:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.