Basic SELECT with filter
SQL
Easy
3 views
Problem Description
You have Customers(customer_id, name, city). Write a query to show only customer_id and name for customers living in 'Mumbai'. Keep it simple: one WHERE condition.
Sample Test Case
Input:
Customers(customer_id, name, city)
Constraints
Think: WHERE comes after FROM
Official Solution
SELECT customer_id, name FROM Customers WHERE city = 'Mumbai';
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!