Query 2-6
Display realtor staff number, name, annual salary as AnnualSalary, monthly salary as Monthly Salary, and age as Age. Roundmonthly salary to 2 decimal places. Round age to years. Sort outputby staff age descending. If there is no birthdate on the record,then list the age as “Unknown”
ST_SST_NAME Annual Salary Monthly Salary Age
—- —————————————- ————————— ——-
Query 2-7
For each branch, list the branch email address, the number ofcharacters in the email address as “Length of Email Address” andthe number of characters preceding the @ as “Characters Precedingthe @” Order the result by email length descending.
BR_EMAIL Length of Email Address Characters Preceding the @
————————- ————————————————-
Answer