Write a query to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table, sorted by project number. The output is shown in Figure P$7\mathrm{.}7.$

Result for total number of hours and charges by project is displayed in $3$ columns, project underscore number, sum of ASSIGN underscore hours and sum of ASSIGN underscore charge. The table has $4$ rows; the values are as follows. Row $1$: project underscore number, $15$; sum of ASSIGN underscore hours, $20\mathrm{.}5$; sum of ASSIGN underscore charge, $1806\mathrm{.}52.$ Row $2$: project underscore number, $18$; sum of ASSIGN underscore hours, $23\mathrm{.}7$; sum of ASSIGN underscore charge, $1544\mathrm{.}08.$ Row $3$: project underscore number, $22$; sum of ASSIGN underscore hours, $27\mathrm{.}0$; sum of ASSIGN underscore charge, $2593\mathrm{.}16.$ Row $4$: project underscore number, $25$; sum of ASSIGN underscore hours, $19\mathrm{.}4$; sum of ASSIGN underscore charge, $1668\mathrm{.}61.$

Figure $P7\mathrm{.}7$