Here's the query I have now:
select quantity, title, round((cost/retail*100),0) "% Profit"
from orders natural join orderitems natural join books
where (cost/retail*100) < 55;
Here's the output:
QUANTITY TITLE % Profit
-------- ------------------------------ ----------
1 HOW TO MANAGE THE MANAGER 48
1 PAINLESS CHILD-REARING 53
2 PAINLESS CHILD-REARING 53
1 SHORTEST POEMS 55
1 PAINLESS CHILD-REARING 53
1 PAINLESS CHILD-REARING 53
1 PAINLESS CHILD-REARING 53
How do I get it look like this?
QUANTITY TITLE % Profit
-------- ------------------------------ ----------
1 HOW TO MANAGE THE MANAGER 48
6 PAINLESS CHILD-REARING 53
1 SHORTEST POEMS 55
Thank you in advance for any help!
select quantity, title, round((cost/retail*100),0) "% Profit"
from orders natural join orderitems natural join books
where (cost/retail*100) < 55;
Here's the output:
QUANTITY TITLE % Profit
-------- ------------------------------ ----------
1 HOW TO MANAGE THE MANAGER 48
1 PAINLESS CHILD-REARING 53
2 PAINLESS CHILD-REARING 53
1 SHORTEST POEMS 55
1 PAINLESS CHILD-REARING 53
1 PAINLESS CHILD-REARING 53
1 PAINLESS CHILD-REARING 53
How do I get it look like this?
QUANTITY TITLE % Profit
-------- ------------------------------ ----------
1 HOW TO MANAGE THE MANAGER 48
6 PAINLESS CHILD-REARING 53
1 SHORTEST POEMS 55
Thank you in advance for any help!