Which SQL statement retrieves customer_id and name from customers where status='active'?

• A. SELECT id, name FROM customers WHERE status = 'active';
• B. SELECT customer_id, name FROM customers WHERE status = 'active';
• C. SELECT customer_id, name FROM customers WHERE status = active;
• D. GET customer_id, name FROM customers WHERE status = 'active';

Answer: (B)

The essential idea is to fetch specific columns from a table and apply a filter to return only the rows that meet a condition. The statement that selects customer_id and name from the customers table and restricts rows to those where status equals the string 'active' does exactly that: it targets the right columns, uses the correct table, and uses a string literal in the WHERE clause to compare the status value. The other statements go wrong in common ways: using a non-existent column name (id instead of customer_id), omitting the necessary quotes around a string (status = active), or using an invalid keyword (GET instead of SELECT).