Q.Write an SQL query to display the Name and City of all customers who live in 'Pune' from the Customer table.

This needs a SELECT that names specific columns and a WHERE clause to filter rows by city.

SELECT Name, City FROM Customer
WHERE City = 'Pune';

The SELECT statement reads data from a table. Two things are needed here:

1. Choosing columns: only Name and City are wanted, so we name those two columns after SELECT (not *).
2. Choosing rows: only customers of Pune are wanted, so we add a WHERE clause with the condition City = 'Pune'. The text value is written inside single quotes.

The complete query is:

SELECT Name, City FROM Customer
WHERE City = 'Pune';

This lists the name and city of only those customers whose city is Pune. If every column of those rows were wanted, we would instead write SELECT * FROM Customer WHERE City = 'Pune';.

SELECT Name, City FROM Customer
WHERE City = 'Pune';

To display all columns of the matching rows instead of just two, use *: SELECT * FROM Customer WHERE City = 'Pune';.

Remember the single quotes around the text value (City = 'Pune', not City = Pune), and do not use SELECT * when only some columns are asked for. End the statement with a semicolon.