sql - SUM MySQL rows of one column and have it group by another -

Hey guys, I'm trying to create a query that tells about a column and the result of the second creates a group is.

I'll show you what I mean by showing my table!

This is my ticket table

Expect the result

As you can see this column releases the app and number and then SUMS the problem per time.

I have something like this currently

  SELECT app, issue, amount (time) tickets by group group by name ASC;  

Although it is not outputting the expected result. Any help would be appreciated.

You need a group by app in addition to issues

  An order issued by the app, name ASC by group, app, issue, amount (time) ticket;