Below are some Universe training notes
LIST BOOK_TITLES STOCK_POSITION CONV "MD00," STOCK_POS_VALUE CONV "MD22,"
LIST BOOK_SALES SALE_DATE CONV "DWADMAYA"
LIST BOOK_SALES SALE_DATE CONV "D-YMD[4,2,2]"
LIST BOOK_SALES SALE_DATE CONV "DJ"
LIST BOOK_SALES SALE_TIME CONV "MTHS" FMT "40R"
LIST BOOK_TITLES GENRE WITH GENRE NE "FICTION"
LIST BOOK_TITLES SHORT_TITLE WITH UNITS <= ALLOCATED
LIST BOOK_TITLES SHORT_TITLE WITH SALE_TIME AFTER "17:00"
LIST BOOK_TITLES SHORT_TITLE WITH UNITS <= ALLOCATED
LIST BOOK_TITLES SHORT_TITLE WITH SHORT_TITLE = "[Spud Murphy]"
LIST BOOK_TITLES SHORT_TITLE WITH SHORT_TITLE SAID "fpud"
LIST BOOK_AUTHORS NAME with SURNAME said Smith
LIST BOOK_AUTHORS WITH SURNAME SAID "BROWN"
LIST BOOK_SALES WITH SALE_ITEMS LIKE "...Artemis Foul..."
LIST BOOK_SALES WITH SALE_ITEMS = "...Artemis Fowl..."
LIST BOOK_SALES SALE_ITEMS
LIST DICT BOOK_SALES WITH SALE_ITEMS = "Artemis Fowl"
LIST BOOK_SALES WITH SALE_ITEMS = "Artemis Foul"
LIST BOOK_SALES WITH SALE_ITEMS LIKE "...A..."
LIST BOOK_SALES SALE_ITEMS
LIST BOOK_SALES WHEN AUTHOR_NAME EQ "Eoin Colfer"
LIST BOOK_TITLES WITH DEPT BY GENRE="FICTION" OR GENRE="FANTASY") AND (PUBLISHER = "HarperCollins" OR PUBLISHER = "BBC Audiobooks"))
LIST BOOK_SALES WITH SALE_DATE AFTER "01/06/2005" AND WITH BEFORE "31/06/2005"
LIST BOOK_SUPPLIES WHEN DELIV_DATE EQ "01/08/2005"
LIST BOOK_SALES WITH EVERY TITLE_NAME LIKE "...Harry Potter..."
LIST BOOK_SUPPLIES WHEN (DELIV_DATE EQ "01/08/2005" AND DELIV_TIME EQ "09:00")
LIST DICT BOOK_SUPPLIES
LIST BOOK_TITLES DEPT GENRE BY.DSND DEPT BY GENRE
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE "TOTAL FOR 'pv'" TOTAL UNITS TOTAL ALLOCATED
Total number of units sold
SORT BOOK_SALES BREAK.ON SALE_DATE "TOTAL:" TOTAL QTY
SORT BOOK_SUPPLIES BREAK.ON @ID "TOTAL:" TOTAL QTY
SORT BOOK_SUPPLIES BREAK.ON @ID "TOTAL:" TOTAL QTY
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE TOTAL UNITS AVG UNITS MAX UNITS MIN UNITS PCT UNITS
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE TOTAL UNITS AVG UNITS COL.HDG "Avg" MAX UNITS COL.HDG "Max" MIN UNITS COL.HDG "Min" PCT UNITS COL.HDG "%" ID.SUP DET.SUP HDR.SUP
SORT BOOK_SALES BREAK.ON SALE_DATE TOTAL QTY AVG QTY COL.HDG "Avg" MAX QTY COL.HDG "Max" MIN QTY COL.HDG "Min" PCT QTY COL.HDG "%" ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE: 'P' DATE:'D'' 00===--"
SORT BOOK_SALES BY.EXP AUTHOR_NAME BREAK.ON AUTHOR_NAME FMT "70L" TOTAL QTY ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE: 'P' DATE:'D'' 00===--" BY QTY
SETPTR ,,,,,, AT MWPR15,FORM 150
COUNT BOOK_TITLES WITH DEPT ="JUNIOR"
SUM BOOK_TITLES UNITS WITH DEPT = "JUNIOR"
STAT BOOK_TITLES UNITS WITH DEPT = "JUNIOR"
SORT BOOK_TITLES TOXML ELEMENTS TO "titles" WITHSCHEMA
SELECT BOOK_TITLES SAVING AUTHOR_ID
SELECT BOOK_TITLES SAVING UNIQUE AUTHOR_ID WITH DEPT = "JUNIOR"
LIST BOOK_TITLES EVAL "'HELLO'"
LIST BOOK_TITLES EVAL "QTY*UNITS"
LIST BOOK_TITLES EVAL "12*13"
LIST BOOK_TITLES EVAL "PRICE*UNITS" COL.HDG "STOCK VALUE" PRICE UNITS
LIST BOOK_TITLES PRICE UNITS EVAL "PRICE*UNITS" COL.HDG "STOCK VALUE" EVAL "PRICE*UNITS*0.175" COL.HDG "STOCK TAX"
LIST BOOK_SALES EVAL "FORENAME[1,1]:' ':SURNAME" COL.HDG "FULLNAME"
LIST BOOK_TITLES EVAL "SHORT_TITLE[1,30]:'... ':TYPE:' ':FORMAT" FMT "50L" COL.HDG "FULL DESCRIPTION"
LIST BOOK_SALES EVAL "OCONV(SALE_DATE,'D'):' ':OCONV(SALE_TIME,'MTS')" FMT "40L" COL.HDG "FULLDATE"
SORT BOOK_SUPPLIES BREAK.ON SUPPLIER_NAME "TOTAL:" TOTAL QTY COL.HDG "TOTAL" PCT QTY COL.HDG "PERCENT" ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE: 'P' DATE:'D'' 00===--" BY QTY
LIST BOOK_TITLES EVAL "SHORT_TITLE:' read by ':READER_NAME" FMT "70L"
LIST BOOK_TITLES EVAL (SHORT_TITLE : ' read by ' : READER_NAME) FMT "70L"
LIST BOOK_TITLES SHORT_TITLE FMT "60L" EVAL "STR('_',10)" COL.HDG "REMARKS"
LIST BOOK_TITLES SHORT_TITLE FMT "40L" EVAL "STR('*',UNITS)" FMT "30L" COL.HDG "UNITS"
LIST BOOK_TITLES EVAL "TRIM(SHORT_TITLE[1,30]:'... ':TYPE:' ':FORMAT)" FMT "50L" COL.HDG "FULL DESCRIPTION"
LIST BOOK_SALES EVAL "OCONV(FIELD(@ID,'*', 1),'D4')"
LIST BOOK_TITLES EVAL "FIELD(SHORT_TITLE,'(', 1)" EVAL "FIELD(FIELD(SHORT_TITLE,'(', 2),')',1)"
LIST BOOK_SALES EVAL "@DATE - SALE_DATE" CONV "MD0"
LIST BOOK_SALES EVAL "@RECORD<3,1>"
LIST BOOK_SALES EVAL "COUNT(@RECORD<3>,@VM) + 1" EVAL "@RECORD<3>" WITH EVAL "COUNT(@RECORD<3>,@VM) + 1" = 4
LIST BOOK_SALES EVAL "DCOUNT(@RECORD<3>,@VM)" EVAL "@RECORD<3>" WITH EVAL "DCOUNT(@RECORD<3>,@VM)" = 4
LIST BOOK_SALES EVAL "@RECORD<3,DCOUNT(@RECORD<3>,@VM),1>" EVAL "@RECORD<3>" WITH EVAL "DCOUNT(@RECORD<3>,@VM)" = 4
LIST BOOK_SUPPLIES PRICE QTY EVAL "PRICE * QTY * REUSE(0.175)" CONV "MD2" EVAL "SUM(PRICE * QTY)"#
LIST BOOK_SUPPLIES EVAL "ORDER_DATE - DELIV_DATE" CONV "MD0" EVAL "SUM(ORDER_DATE - DELIV_DATE)" CONV "MD0"
LIST BOOK_SALES EVAL "XLATE('BOOK_TITLES',TITLE_ID,8,'X')"
LIST BOOK_SUPPLIES EVAL "TRANS(BOOK_TITLES,TITLE_ID,ISBN,'X')" EVAL "XLATE('BOOK_TITLES',TITLE_ID,12,'X')"
LIST BOOK_TITLES PRICE DEPT SHORT_TITLE EVAL "IF DEPT = 'JUNIOR' THEN '*': OCONV((PRICE * 0.9),'MD2') ELSE OCONV(PRICE,'MD2')"