CBSE Class 12 Informatics Practices
Question 76 of 81
MySQL Functions — Question 6
Back to all questions 6
Question Perform the following question based on these tables :
table PAYDAY (contains one column only)
CycleDate DATE
table ADDRESS ( contains following eight columns)
LastName VARCHAR(25),
FirstName VARCHAR(25),
Street VARCHAR(50),
City VARCHAR(25)
State CHAR(2),
Zip NUMBER,
Phone VARCHAR(12),
Ext VARCHAR(5)
Write a query to show the city of user with first name as 'MARK'.
SELECT City
FROM Users
WHERE FirstName = 'MARK';