How can I add a row number to the table.  I want the rank shown for my salespeople  In MYSQL, I'd do something like this.  but SET is not support on your tool

SET @row_number:=0;
select  (@row_number:=@row_number + 1) ,display_name, Sales from (
select  display_name, count(amount) as Sales from wp_affiliate_wp_referrals r 
inner join wp_affiliate_wp_affiliates a on a.affiliate_id = r.affiliate_id
inner join wp_users u on u.ID = a.user_id

where r.status = 'unpaid' and r.affiliate_id not in (7,8,9)
group by r.affiliate_id order by count(amount) desc ) as sq;

This is not a table, it is a query, I have a query that ranks my salespeople by sales and I want to be able to show a number on my output

1. Jim

2 Bob

3. Bill

etc.  I was able to do it with a SET statement, below, but this was not supported in your tool.  So Irigured there is probably a way to do a calculated column that would put the number using yoru tool, but I could not find a way to add row numbers to the output.  But this is not a table, it's the reesults of a query

On another note.  When I do a query and I have it sorted, when I pass it to the chart, it is no longer sorted and i can't show the chart series in the correct order.  How do I sort a chart series.