write a sql query for list of campaigns that have a sequence of events with more sell transactions than buy transactions. Transactions are considered in the order they appear in the table.

A sequence is a number of consecutive transactions with the same campaign$\_$id$.$

The result should be in the following format : campaign, netsells$\_$count, netsells$\_$total.

Results should be sorted descending by netsells$\_$total.

sample input data

Campaigns

id name

$1$ Engineering

$2$ Legal

$3$ Engineering

Events

Camapign$\_$id Type amount

$2$ buy $54\mathrm{.}70$

$1$ sell $76\mathrm{.}02$

$2$ sell $29\mathrm{.}47$

$1$ buy $46\mathrm{.}32$

$3$ sell $2\mathrm{.}96$

$2$ sell $28\mathrm{.}96$

$3$ buy $66\mathrm{.}31$

$2$ buy $89\mathrm{.}60$

$1$ sell $28\mathrm{.}47$

$1$ buy $51\mathrm{.}97$

$1$ sell $48\mathrm{.}89$

$3$ sell $17\mathrm{.}37$

$3$ sell $6\mathrm{.}65$

$2$ buy $9\mathrm{.}41$

$1$ sell $7\mathrm{.}13$

$1$ sell $64\mathrm{.}50$

$1$ buy $31\mathrm{.}01$

$2$ sell $10\mathrm{.}51$

$2$ buy $9\mathrm{.}89$

$3$ sell $74\mathrm{.}79$

$2$ sell $3\mathrm{.}45$

$2$ sell $54\mathrm{.}70$

$2$ sell $76\mathrm{.}02$

output:

Campaign netsells$\_$count Netsells$\_$total

Engineering $2173\mathrm{.}01$

legal $1134\mathrm{.}17$

Explanation:

$1.$Transactions are considered in the order they appear.A sequence is a number of consecutive transactions with the same campaign$\_$id$.$

A sequence should be reported if the number of sell transactions exceeds the number of buys transactions.

the first sequence in the sample tables is

Campaign$\_$id type amount

$1$ sell $28\mathrm{.}47$

$1$ buy $51\mathrm{.}97$

$1$ sell $48\mathrm{.}89$

There are two sell transactions and only one buy transactions, so this sequence is reported. The sell transactions add to $77\mathrm{.}36$ and the name is 'Engineering'.

$2.$The next sequence has only sell transactions, so it is reported. The sell transactions add to $24\mathrm{.}02.$ The name is 'Engineering'.

campaign$\_$id type amount

$3$ sell $117\mathrm{.}37$

$3$ sell $6\mathrm{.}65$

$3.$The third sequence qualifies with two sells and one buy. The sell transactions sum to $71\mathrm{.}63,$ and the name is 'Engineering'.

Campaign$\_$id type amount

$1$ sell $7\mathrm{.}13$

$1$ sell $64\mathrm{.}50$

$1$ buy $31\mathrm{.}01$

$4.$The final sequence does not qualify since it does not have more sell than buy transactions.

campaign$\_$id type amount

$2$ sell $10\mathrm{.}51$

$2$ buy $9\mathrm{.}8$

$5.$The qualifying sequences are associated with $2$ different campaigns id $1$ and $3$

Both campaigns are named Engineering. The total of sell amounts is $77\mathrm{.}36+24\mathrm{.}02+71\mathrm{.}63=173\mathrm{.}01$

I need my output to be this:

Campaign netsells$\_$count Netsells$\_$total

Engineering $2173\mathrm{.}01$