home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 3 / Developers_Source_Vol_03_1996.iso / parad / jan95 / bt_fig07.gif < prev    next >
Graphics Interchange Format  |  1995-09-26  |  19.9 KB  |  663x597  |  4-bit (14 colors)
   ocr: Paradox for Windows File Edit View Table Record Properties Tools Window Help - - K 44 > PI L alb - SQL Editor WYURKKUI<untitied> SELECT Orders.Customer No', SUM/Orders.Total Invoice'] FROM Orders GROUP BY Orders.Customer No' ORDER BY Orders.'Total Invoice' Table : HAHOMEWERRY.JANSWER.) V ANSWER Customer No Sum of Total Invoice 1 1 3,158 $536.80 2 3,984 $4,517.70 3 5,163 $4,829.75 4 6,812 $4,872.00 5 4,684 $4,894.95 6 4,312 $6,300.00 7 5,151 $6,675.95 8 5,412 $7,423.35 9 3,151 $9,524.00 10 4,652 $9,653.00 11 5,165 $9,/93.55 12 2,165 $11,954.85 13 1,551 $12,223.25 14 3,055 $12,468.80 15 3,051 $1 ...