ocr: - ESPERANT QuerySysten- fdsesperantvmall - - a Bai BE M Ele Edit Query Optlons window Help PRDEEORESOREOEBEE ESPERANT Query soL COMPARE THE AVERAGE ORDERDOLLARSFOR ORDERS DROPTEMPIABLE ESPIEMPI THAT HAVE ORDER DATE FROM JANUARY 11 199270. JUNE 30 1992. AGAINST THE AVERAGE ORDER DOLLARS FOR ORDERS CREATE TEMPTABLE ESPTEMPI THAT MAVE ORDER DATE FROM JULY11992T01 DECEMBER31 SELECT AYG(ULORDERLDOLLARS) 1992 FROM ORDERSTI WHERE (.ORDER_DATE)* (di 1992-01-01 00:00:00) ANDTLORDER_DATE <= (d 992-06-30 23:5959)) DROPTEMPTABLEESPTEMP2 CREATE TEMPTABLE ESPTEMPZ SELECT, AYGUZORDER_DOLLANS FROM ORDERST2 WH ...
