please help me write these 7 queries in SQL for class

1. Write a query that will show all probation officers 2. Write a query that will show the first and last names of probation officers 3. Now write a query that shows first and last name of probation officers. Include the field probuid. but rename prebuid to probation officer ID. 4. 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. 5. Write a query that will sencat 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. 6. List the last name and first name of all authors in only 1 column. Add a comma to separate the two names. 7. Run a query that will return the order\#, itemH, isbn, quantity, Baideach. Include in the query a arithmetic operation that will total quantity and paideach, Alias the virtual column so it is labeled Item Total