$1\mathrm{.}9$ Suppose you work for alderman Michael Rodriguez in the office of ward #$22.$ The alderman would like to discuss progress on the cases of a particular category of crime with commanders of the districts where the crimes occurred. Generate a list to facilitate this discussion.

List all crimes reported in ward #$22$ with an IUCR primary description of "PUBLIC PEACE VIOLATION".

Show the primary$\_$description, secondary$\_$description, district, arrest, case$\_$number, commander, district phone number, block, and community area number.

Sort the results by secondary description then by district then by case$\_$number then by arrest.