//listing all the products
//SQL Equivalent: select * from products
OUTPUT(products);


//Filtering information
//SQL Equivalent: select * from products where productCode='S32_1374'
OUTPUT(products(productCode='S32_1374'));

OUTPUT(
products(
   Std.Str.ToUpperCase(productCode)
     ='S32_1374')
      );

//Output fields
//SQL Equivalent: select productCode, productName from products
OUTPUT(products, {productCode, productName});

//Sorting
//SQL Equivalent: select * from products order by productName
OUTPUT(SORT(products, productName));

//Counting
//SQL Equivalent: select COUNT(*) from products
//where productLine='Vintage Cars'

OUTPUT(

COUNT(
 products(
   Std.Str.ToUpperCase(productLine)
     ='VINTAGE CARS'))
);

//Grouping
//SQL Equivalent: select * from products
//group by productLine
OUTPUT(
GROUP(
     SORT(products, productLine),
     productLine)
);

//Aggregation

//SQL Equivalent: select SUM(buyPrice) from products
OUTPUT(
SUM(products, buyPrice)
);

//SQL Equivalent: select AVG(buyPrice) from products
OUTPUT(
AVE(products, buyPrice)
);

//SQL Equivalent: select MAX(buyPrice) from products
OUTPUT(
MAX(products, buyPrice)
);

//Crosstab
//SQL Equivalent: Select productLine, COUNT(*)
//from products group by productLine
OUTPUT(
TABLE(products,
  {
     productLine;
     productLineCount:= COUNT(GROUP);
  }, productLine)
);