escaping like quiz.sql

/*****************************************************************************
Copyright (c) 2018 SQL Workbooks LLC
Terms of Use: https://sqlworkbooks.com/terms-of-service/
Contact: help@sqlworkbooks.com
*****************************************************************************/

--How many rows will this return?
SELECT *
FROM 
(VALUES 
    ('corgis'),
    ('have'),
    ('100%'),
    ('more'),
    ('sploot!')
) as t(col1)
WHERE 
    col1 like '%';
GO


--How many rows will this return?
SELECT *
FROM 
(VALUES 
    ('corgis'),
    ('have'),
    ('100%'),
    ('more'),
    ('sploot!')
) as t(col1)
WHERE 
    col1 like '%' ESCAPE '!';
GO



--How many rows will this return?
SELECT *
FROM 
(VALUES 
    ('corgis'),
    ('have'),
    ('100%'),
    ('more'),
    ('sploot!')
) as t(col1)
WHERE 
    col1 like '%!%' ESCAPE '!';
GO



--How many rows will this return?
SELECT *
FROM 
(VALUES 
    ('corgis'),
    ('have'),
    ('100%'),
    ('more'),
    ('sploot!')
) as t(col1)
WHERE 
    col1 like '!%' ESCAPE '!';
GO



--How many rows will this return?
SELECT *
FROM 
(VALUES 
    ('corgis'),
    ('have'),
    ('100%'),
    ('more'),
    ('sploot!')
) as t(col1)
WHERE 
    col1 like '100!%' ESCAPE '!';
GO