Title: More SQL options
Last modified: July 9, 2020

---

# More SQL options

 *  Resolved [xsilverdicex](https://wordpress.org/support/users/xsilverdicex/)
 * (@xsilverdicex)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/more-sql-options/)
 * Please let us do calculations in the sql query like so:
    Select data1, data2(
   data1/data2) AS ‘Total’ FROM database;
 * It would build a table with 3 columns
    Data1 Data2 and Total – Total would show
   a value of Data1 divided by Data 2 in the above example.

Viewing 1 replies (of 1 total)

 *  Plugin Support [juniorninja](https://wordpress.org/support/users/mrkevinmiller/)
 * (@mrkevinmiller)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/more-sql-options/#post-13280663)
 * Hello [@xsilverdicex](https://wordpress.org/support/users/xsilverdicex/),
    Can
   you please open a support ticket here: [https://wpmanageninja.com/login](https://wpmanageninja.com/login)
 * Provide some more information regarding your issue while submitting the support
   ticket, we will try to assist further.
    Thanks

Viewing 1 replies (of 1 total)

The topic ‘More SQL options’ is closed to new replies.

 * ![](https://ps.w.org/ninja-tables/assets/icon-256x256.png?rev=3337819)
 * [Ninja Tables – Easy Data Table Builder](https://wordpress.org/plugins/ninja-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ninja-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ninja-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/ninja-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ninja-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ninja-tables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [juniorninja](https://wordpress.org/support/users/mrkevinmiller/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/more-sql-options/#post-13280663)
 * Status: resolved