Given customers table in the sales DB . Which of the queries should return the information about all the customers from California state (value of the state column equals 'CA')

Question

Given    customers  table in the sales DB .  Which of the queries should return the information about all the customers from California state (value of the  state  column equals 'CA')

Accepted Answer

SELECT
    *
FROM
    sales.customers
WHERE
    state = 'CA';

Answer

SELECT
    *
FROM
    sales.customers
WHERE
    state LIKE 'CA';

Answer

SELECT
    *
FROM
    sales.customers
WHERE
    state EQUALS  'CA';

Answer

SELECT
    *
FROM
    sales.customers
WHERE
    state BETWEEN 'C' AND 'A';

Answer

SELECT
    *
FROM
    sales.customers
WHERE
    state IN 'CA';

Crowdly

Given customers table in the sales DB . Which of the queries should return ...

Want instant access to all verified answers on softserve.academy?