Sales by Managers (Donut)

select first 10 * from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Areas - top 10 (Pie)

select first 10 * from ( select * from country order by area desc )

Horizontal Bars

select first 10 * from ( select e.firstname, e.lastname, -1*sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Vertical Bars

select first 10 lastname, sales, sales/10000 +1 q2, sales/10000 - 3 q1, sales/10000 + 3 q3, sales/10000 - 3 - rand()*10 qmin, sales/10000 + 8 qmax from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Vertical Bars - stats

select first 10 lastname, sales, sales/10000 +1 q2, sales/10000 - 3 q1, sales/10000 + 3 q3, sales/10000 - 3 - rand()*10 qmin, sales/10000 + 8 qmax from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Stacked Bars

select first 80 x.*, '10000' as e from ( select e.firstname, e.lastname, extract(year from saledate) syear, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2,3 order by 1,2,3 ) x

Vertical Stacked Bars

select first 80 x.*, '10000' as e from ( select e.firstname, e.lastname, extract(year from saledate) syear, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2,3 order by 1,2,3 ) x

Side-by-Side Bars

select first 80 x.*, '10000' as e from ( select e.firstname, e.lastname, extract(year from saledate) syear, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2,3 order by 1,2,3 ) x

Areas

select first 10 lastname, sales/100000 sales from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Lines

select first 10 lastname, sales/100000 sales from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Scatter

select first 10 lastname, sales/100000 sales from ( select e.firstname, e.lastname, sum(o.itemstotal) sales from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 3 desc )

Bubble

select first 20 * from ( select e.firstname, e.lastname, sum(o.itemstotal) sales, count(*) xcount from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 1,2 )