1. Write a query that will show all probation officers SQL> Select 2 from officer; 2. Write a query that will show the first and last names of probation officers SQL> Select firstiname, lastname 2 from officer; 3. Now write a query that shows first and last name of probation officers. Include the field probid but rename probjid to probation officer ID. SQL> Select firstname, lastname, RCobnid as 'probation officer ID' 2 from officer; 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. SQL> Select crimert 11 ", "Itotalcharges "fiotal Charges" 2 from bfficers; 1. Write a query that will show all probation officers SQL> Select 2 from officer; 2. Write a query that will show the first and last names of probation officers SQL> Select firstiname, lastname 2 from officer; 3. Now write a query that shows first and last name of probation officers. Include the field probid but rename probjid to probation officer ID. SQL> Select firstname, lastname, RCobnid as 'probation officer ID' 2 from officer; 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. SQL> Select crimert 11 ", "Itotalcharges "fiotal Charges" 2 from bfficers