How to use single quote inside a EXECUTE statement SQLSERVER

Question

how to get this code executed in SQLSERVER

BEGIN 
    EXECUTE('CREATE VIEW [dbo].[dummy] AS select cid,CASE 
        WHEN email IS NOT NULL
            THEN 'RESTRICTED' + right(email, patindex('%@%', reverse(email)))
        ELSE NULL
        END as email_id
from (
select 11 as cid,'abcd123@email.com' as email
) A')
END

Answer 1

Double the single quotes:

BEGIN 
    EXECUTE('CREATE VIEW [dbo].[dummy] AS SELECT 1 AS Dummy ,''hello'' as name')
END

Answer 2

    BEGIN 
        EXECUTE('CREATE VIEW [dbo].[dummy] AS select cid,CASE 
            WHEN email IS NOT NULL
                THEN ''RESTRICTED'' + right(email, patindex(''%@%'', reverse(email)))
            ELSE NULL
            END as email_id
    from (
    select 11 as cid,''abcd123@email.com'' as email
    ) A')
    END