- employeesInOffice: The employeesInOfficeSQL query takes in an office code and prints the details of all the employees in that office.
- listOffices: The listOfficesSQL query lists all the offices in the database. When office information is printed, all the employees that belong to an office are also printed using a nested query, which refers to the employeesInOfficeSQL query (invoked by the "employeesInOffice" operation).
- customerNameSQL: The customerNameSQL query takes in the customer number as a parameter and returns the customer name. In the result section of this query, there is no "rowName" defined (only an element wrapper). With this option, a separate element will not be created for every record in the result. However, the record content will be directly added to the outer element. This is best used in a query where there is only one record to be returned.
- customerOrders: The customerOrdersSQL query prints the details of all the orders that are in the database. In the result elements, a nested query that refers to the customerNameSQL query is used. In this way, the name of the customer who placed the order can also be returned with the order details.
See Data integration for a definition of data services and operations.