Solutions

Solutions to modifying the query excercise.

Parent topic: Filtering Data

Modifying the Query: Solution

  1. The modified query filters for rows with either "EBAY" or "SWY" in the Symbol column.

  2. The following WHERE clauses produce the requested output:

    • WHERE Symbol = "MRK" AND Volume > 400 AND Price < 34

    • WHERE Symbol = "MRK" OR Symbol = "EBAY" AND Volume > 1000 AND Volume < 3000

    • WHERE Price * Volume <= 3000

Questions

  1. Sybase CEP Workspaces are grouping mechanisms you can use to organize your projects, while Sybase CEP Environments are only available in Sybase CEP Studio, and allow you to view and work with different subsets of your workspaces.

  2. An input adapter translates data from an external format to one that Sybase CEP Engine can process, while an output adapter translates data from Sybase CEP Engine to an external format. You attach an adapter to a stream.