Hinamalik

The New York Department of Motor Vehicles wants to create four queries. The first query provides summary data on the number of tickets by city and violation. The second query summarizes the total tickets by violation. The third query provides summary data for the total fines assessed against each driver who has had a ticket. Use Design view to create the summary queries. Edit these queries to add fields, aggregate functions, and sorting. Save and run the queries. Finally, create a crosstab query...