After careful consideration, we have decided to discontinue Amazon Kinesis Data Analytics for SQL applications:

1. From **September 1, 2025**, we won't provide any bug fixes for Amazon Kinesis Data Analytics for SQL applications because we will have limited support for it, given the upcoming discontinuation.

2. From **October 15, 2025**, you will not be able to create new Kinesis Data Analytics for SQL applications.

3. We will delete your applications starting **January 27, 2026**. You will not be able to start or operate your Amazon Kinesis Data Analytics for SQL applications. Support will no longer be available for Amazon Kinesis Data Analytics for SQL from that time. For more information, see [Amazon Kinesis Data Analytics for SQL Applications discontinuation](discontinuation.md).

# Examples: Windows and Aggregation
<a name="examples-window"></a>

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

**Topics**
+ [Example: Stagger Window](examples-window-stagger.md)
+ [Example: Tumbling Window Using ROWTIME](examples-window-tumbling-rowtime.md)
+ [Example: Tumbling Window Using an Event Timestamp](examples-window-tumbling-event.md)
+ [Example: Retrieving the Most Frequently Occurring Values (TOP\$1K\$1ITEMS\$1TUMBLING)](examples-window-topkitems.md)
+ [Example: Aggregating Partial Results from a Query](examples-window-partialresults.md)