Write a query that will show all probation officers

Write a query that will show the first and last names of probation officers

Now write a query that shows first and last name of probation officers. Include the field prob id

but rename prob id to probation officer ID$.$

Write a query that will show crime id$,$ and the total charges for each crime ID$.$ Include an alias

for the total charges column called Total Charges.

Write a query that will concat the last and first names of criminals into one column. Add a space

and comma between the last and first name of criminals. Give the column the alias Criminal

Name.

List the last name and first name of all authors in only $1$ column. Add a comma to separate the

two names.

Run a query that will return the order#$,$ item#$,$ isbn, quantity, paideach. Include in the query a

arithmetic operation that will total quantity and paideach. Alias the virtual column so it is

labeled Item Total