Write a query to show the current date and time.

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'.

Write the SQL queries which will perform the following operations :

(i) To display the year from your Date of Admission which is '2023-05-15'.

(ii) To convert your email id 'ABC@XYZ.com' to lowercase.

(iii) To remove leading spaces from a string 'my country'.

(iv) To display current date.

(v) To display the value of 10⁶.

Write a query against the EMPL table to show the names of all employees concatenated with their jobtypes.