1.从表中选择积分大于3000分的顾客
    SELECT *
    FROM Customers
    WHERE points > 3000

    2.从表中选择位置属于VA的顾客
    SELECT *
    FROM Customers
    WHERE state = ‘VA’

    3.从表中选择位置不属于VA的顾客
    第一种写法 (not equal运算符)
    SELECT
    FROM Customers
    WHERE state != ‘VA’
    第二种写法(<>运算符)
    SELECT

    FROM Customers
    WHERE state <> ‘VA’

    4.从表中选择出生日大于1990-01-01的顾客
    SELECT *
    FROM Customers
    WHERE birth_date > ‘1990-01-01’

    5.得到今年的订单
    SELECT *
    FROM Orders
    WHERE order_date >= ‘2019-01-01’