$1\mathrm{.}9$ Suppose you work for alderman Nicholas Sposato in the office of ward #$38.$ 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 #$38$ with an IUCR primary description of "WEAPONS VIOLATION".

Show the primary$\_$description, secondary$\_$description, district, arrest, case$\_$number, commander, district phone number, FBI code, and location description.

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