Amazon Kinesis Data Analytics for SQL Applications Developer Guide
SQL Developer Guide

Examples: Windows and Aggregation

This section provides examples of Amazon Kinesis Data Analytics applications that use windowed and aggregate queries. (For more information, see Windowed Queries.) Each example provides step-by-step instructions and example code for setting up the Amazon Kinesis data analytics application.