Continous Queries
CQ 1
Query part: SELECT Company.name, Company.Capital, stock.price FROM Stock, Company WHERE Stock.Company_name = Company.name AND Company.name = « Bayer AG »
Trigger part1: 6pm every day
Trigger part 2: company_name = « Bayer AG » AND DeacreaseBy(Stock.price) > 5%