Need help? We are here

 

Create a query for the following: you should have 3 queries from above plus 5 the ones below for a total of 8 queries 

  1. How many primary factor Alcohol related tickets issued in the database.
  2. Which primary factor has the least tickets and how many tickets are there
  3. Which primary factor has the most tickets and how many tickets are there
  4. Create a new query that identifies how many tickets M and F have, in other words who has the most ticket Male or Female
  5. In the ticketcountby city and factor which city has the most tickets