1.选择名字以B字母开头的客户
    SELECT *
    FROM customers
    WHERE last_name like ‘b%’

    2.选择名字以Brush词开头的客户
    SELECT *
    FROM customers
    WHERE last_name like ‘brush%’

    3.选择名内有B字母出现的客户
    SELECT *
    FROM customers
    WHERE last_name like ‘%b%’

    4.选择名字以y字母结尾的客户
    SELECT *
    FROM customers
    WHERE last_name like ‘%y’

    5.选择名字以y字母结尾的客户，且名字长度为6
    SELECT *
    FROM customers
    WHERE last_name like ‘_y’ —(五根下划线)

    6.选择名字以b开头y字母结尾名字长度为6的客户
    SELECT *
    FROM customers
    WHERE last_name like ‘b____y’ —(四根下划线)

    7.选择地址内包含TRAIL 或者 AVENUE客户,且他们
    的手机号以6结尾
    SELECT *
    FROM customers
    WHERE address like (‘%TRAIL%’ OR ‘%AVENUE%’)
    AND phone like ‘%6’