Problem: Microsoft Access
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.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.