This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
Arya Stark knows that winter is coming. In the castle where she lives, Arya decided to install SQL Server and create a table that indicates the people she knows.
CREATE TABLE GoT
(char_id varchar(25),
char_name varchar(25))
GO
![Advanced SQL - Finding Middle Rows [1]](https://i0.wp.com/ramkedem.com/wp-content/uploads/2016/10/word-image-22.png?resize=302%2C255&ssl=1)