-- requires the country sample data from
-- charts.zip on http://dbentrance.com/

plot rotatedbarchart
   only 20 xlabels, light red bars
  with
    title x "Population (millions)"
    horizontal gridlines
    barwidth 0.85
select
  name, population/1000000 from country
  order by population desc
  limit 20;