Answered You can hire a professional tutor to get the answer.

QUESTION

I'm stuck with these last few questions.

I'm stuck with these last few questions. please help with this sql assignment.

By the way, this is one whole assignments that has multiple questions. I'm stuck with question 12-15

table name is tickets;

Log in to phpMyAdmin and select database premiere and table tickets. produce a query that answers each question below. Submit your SQL statements. Please make sure that your SQL statements are very clearly legible.  

*HINT: to get parking tickets search for the word parking in the violation field.

  1. What are the 10 tickets with the highest point values?
  2. How many tickets are there?
  3. What is the total point value for all of the tickets combined?
  4. What is the lowest ticket point value?
  5. What is the average ticket point value?
  6. Display the total number of parking tickets.
  7. Display the total number of tickets that are between 2 and 5 points, inclusive.
  8. How many different officers are there in the ticket table?
  9. Display the total number of parking tickets issued by officer JKT.
  10. Display the total number of parking tickets issued by officers JKT or LYA.
  11. What is the average ticket point value for each officer?
  12. Which officer issued the most tickets?// starting from here is what I need help with
  13. Display the number of tickets issued by each officer who has more than 5 tickets.
  14. Display the officer and number of tickets for all parking violations grouped by officer_initials.
  15. Display the officer_initials of all officers that have issued more than twenty tickets.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question