Home History History (JSON) History (XML) History (CSV) Data Access SQLite Import Definition SQLite Data Items SQLite Data Info SQLite Products Data SQLite Products with no CSS style SQLite just Products QuantityPerUnit data SQLite first 5 Products SQLite last 5 Products Products items only: ProductName and CategoryID Products filter: SupplierID = 11 Products with extra expression column: (UnitsInStock+UnitsOnOrder) Sorting Products sorted by UnitsInStock (ascending) Products sorted by UnitsInStock (descending) Products sorted by UnitsInStock+UnitsOnOrder Sort Restaurants by subcolumn "address.building" Queries Orders OrderID and OrderDate Orders EmployeeID and ShipCountry Orders DISTINCT EmployeeID and ShipCountry SQL select * from Customers Summaries Count of Orders by ShortMonth(OrderDate) Sum of Products UnitsInStock Average of "Order Details" UnitPrice and sum of Quantity Sum of "Order Details" Quantity by Categories CategoryName Sum of "Order Details" having Quantity>5000 by Categories CategoryName Charts Chart (HTML5 Live Javascript) of Sum of "Order Details" Quantity by Shippers ShipperID HTML5 Height=200,Width=300,FontZoom=60 Chart (png) of Sum of "Order Details" Quantity by Shippers ShipperID Chart (jpg) of Sum of "Order Details" Quantity by Shippers ShipperID Chart 2D and "Flat" theme 1280x720 Chart of Sum of "Order Details" Quantity by Shippers ShipperID, Quarter and Year of Orders.OrderDate
![Chart (png) of Sum of "Order Details" Quantity by Shippers ShipperID](http://steema.cat:15015?data=SQLite_demo|"Order Details"&format=.png&summary=sum(Quantity);Shippers.ShipperID){kind=link}
![Chart (jpg) of Sum of "Order Details" Quantity by Shippers ShipperID](http://steema.cat:15015?data=SQLite_demo|"Order Details"&format=.jpg&summary=sum(Quantity);Shippers.ShipperID){kind=link}
![Chart 2D and "Flat" theme 1280x720](http://steema.cat:15015?data=SQLite_demo|"Order Details"&format=.png&view3d=false&theme=flat&width=1280&height=720&summary=sum(Quantity);Shippers.ShipperID){kind=link}