Show via query how many days remain until Christmas. Round fractional days up using the numeric function ROUND.

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.

Write a query against the ADDRESS table to select a list of names and phone numbers. The output should match these requirements :

• The name column should contain both the first and last names with a blank space between them. Use the string concatenation.
• The second column will contain the phone number.
• Phone number should be in the format (999) 999-9999. Use the SUBSTR function and CONCAT.
• Order the query by last name then first name.

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)