Create a query for the following: you should have 3 queries from above plus 5 the ones below for a total of 8 queries
- How many primary factor Alcohol related tickets issued in the database.
- Which primary factor has the least tickets and how many tickets are there
- Which primary factor has the most tickets and how many tickets are there
- Create a new query that identifies how many tickets M and F have, in other words who has the most ticket Male or Female
- In the ticketcountby city and factor which city has the most tickets