Combine conditions with =, <, >, AND, OR and NOT.
Combine conditions with =, <, >, AND, OR and NOT. Read the query line by line and identify the input table, the transformation, and the shape of the result before running it.
SELECT name, country FROM customers WHERE country = 'India' AND name LIKE 'A%';
Before running the example, predict the output columns and whether the query returns one row, many rows, or possibly no rows.
In your own words, explain the main SQL feature in today’s lesson and why it answers the question.
Recall prompt: Use AND to require both conditions. Use LIKE 'A%' for names beginning with A. Close this page section mentally and explain the query from memory before proceeding.
Return names of customers from India whose names begin with A.
Use AND to require both conditions. Use LIKE 'A%' for names beginning with A.