morazain

sqltable lets you use a short code to make a tabular representation of the data returned by a query 
You can control the class for the table, the even and odd rows, each column or a row, the header row and the footer row. 
You can specify functions such as min, max and sum of a column to dipaly on the footer.

Sql Table Plugin

sqltable lets you  use a short code to make a tabular representation of the data returned by a query

joeyoungblood

WP Business Intelligence Lite allows you to powerfully display responsive data tables and charts on your website. This plugin is simple to use and allows you to connect with your wordpress database and display the data in real time. Once you have created at least one SQL query that retrieves data from your DB, you can define the type of chart (bar, donut, line, or grouped bar) or table to be used to display them. A simple shortcode embeds the chart or table in any post or page. Each page refresh retrieves the data from the DB so that the information in the chart or table is always up-to-date.
Installation guide, FAQs and support can be found at <a href="http://www.wpbusinessintelligence.com/support" rel="nofollow ugc">WP Business Intelligence Support</a>
<a href="http://www.wpbusinessintelligence.com/demos" rel="nofollow ugc">WP Business Intelligence Demos</a>
In order to use your own live MySQL, MS SQL, or PostgreSQL database with WP Business Intelligence, purchase the Pro version of WP Business Intelligence from the <a href="http://www.wpbusinessintelligence.com" rel="nofollow ugc">WP Business Intelligence web site</a>
We are actively developing this plugin and would love to hear from you with feature requests. <a href="http://www.wpbusinessintelligence.com/contact/" rel="nofollow ugc">Contact Us.</a>
Some icons provided by <a href="https://fontawesome.com/license" rel="nofollow ugc">Font Awesome</a>
<h4>Features</h4>
<ol>
<li>Live connection to your WordPress DB via custom SQL queries</li>
<li>Responsive charts/tables</li>
<li>Works in Chrome, Firefox, IE9+</li>
<li>Charts based on <a href="https://eventbrite.github.io/britecharts/tutorial-kitchen-sink.html" rel="nofollow ugc">Britecharts</a></li>
<li>Tables build on <a href="https://datatables.net/" rel="nofollow ugc">Datatables</a></li>
</ol>

WP Business Intelligence Lite

As a long-time user of this plugin I had been dismayed with how it had eroded in recent years. A few months ago the developer and I reached an agreement for me to take over the plugin so my team and I could start making updates. 

Since December of last year we have fixed all of the known bugs in the display of the charts, fixed the tooltip display, introduced more free charts for WP users, fixed a handful of database query bugs, added a feature to give your charts and graphs a name, added animation to all charts and graphs, and added a feature to give charts and graphs a caption. 

This is only the beginning of our updates, but after 3 months of hardwork the issues with this plugin that were breaking reporting dashboards for us and our clients have now been fixed. We have an aggressive roadmap to bring more charts, features, and functionality to both the free and paid version of this plugin and I am excited to keep using it to build business intelligence dashboards and to display in-depth data on our clients websites.

Problems Getting Fixed, Great Charts!

Dynamic web charts and tables for your site! Connect to your live WordPress instance DB to retrieve data in real-time and update charts and tables!

Sql Table Plugin vs WP Business Intelligence Lite