you can answer this question in java or any language of your choice

Task 1 English Given a table invoice_items with the following structure: create table invoice_items inv_num integer not null, item varchar(10) not null, price integer not null ); write an SQL query that returns a list of invoices (inv_num) with the total price of each (sum). The list should be ordered by inv_num (in descending order). Examples: 1. Given: inv_num item price 10 b 15 1 7 your query should return: inv_num sum 3 1 25 7 2. Given: inv_num item price 10 11 11 12 12 A C D D 13 20 4 your query should return: inv_num sum 12 8 11 24 10 13 Copyright 2009-2021 by Codility Limited. All Rights Reserved. Unauthorized copying- publication or disclosure prohibited