Write a query to show the city of user with first name as MARK.

Table ADDRESS (contains following eight columns)

 

Last Name	VARCHAR (25)
FirstName	VARCHAR (25)
Street	VARCHAR (50)
City	VARCHAR (25)
State	CHAR (2)
Zip	NUMBER
Phone	VARCHAR(12)
Ext	VARCHAR(5)

Q. Write a query to show the city of user with first name as 'MARK'.

Answer =

SELECT City from ADDRESS WHERE FirstName like ‘MARK%’;