2 ms·
Skip to page 11 in the PDF for examples. MEMBERS(NAME, ADDRESS, BALANCE) ORDERS(ORDER_NO, NAME, ITEM, QUANTITY) SUPPLIERS(SNAME, SADDRESS, ITEM, PR
by irq-1 3y ago
Skip to page 11 in the PDF for examples.
MEMBERS(NAME, ADDRESS, BALANCE)
ORDERS(ORDER_NO, NAME, ITEM, QUANTITY)
SUPPLIERS(SNAME, SADDRESS, ITEM, PRICE)
1. Print the names of members in the red:
LIST MEMBERS : BALANCE < 0 % NAME
i.e. select members with negative balance and
project out their names