{"id":23645,"date":"2025-07-25T13:29:08","date_gmt":"2025-07-25T13:29:08","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=23645"},"modified":"2025-07-25T13:29:08","modified_gmt":"2025-07-25T13:29:08","slug":"jetengine-setting-calculated-columns-and-grouping-results-for-sql-queries","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/jetengine-setting-calculated-columns-and-grouping-results-for-sql-queries\/","title":{"rendered":"How to Set Calculated Columns and Grouping Results for SQL Query"},"content":{"rendered":"\n

With the help of the \u201cSQL\/AI Query<\/a>\u201d type of the JetEngine<\/em> plugin, you can create a query with database table values.\u00a0<\/p>\n\n\n\n

The Group Results<\/strong> feature allows you to combine query results by duplicate values in one of the columns. For example, you have columns for users and their corresponding countries. You can group the selection by the column with countries, and then only one user from each country will be displayed by default. If you combine Group results<\/strong> with the Calculated Columns<\/strong> feature, you can display a list of countries along with some calculated values for all rows (for example, the country and the number of users from this country in the database).<\/p>\n\n\n\n

Another example is counting the number of posts each author has published, which will be described in this tutorial.<\/p>\n\n\n\n

To create a new \u201cSQL\/AI Query\u201d, go to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong> and press the \u201cAdd New\u201d <\/strong>button.<\/p>\n\n\n\n

Give the new query a Name <\/strong>and <\/strong>choose \u201cSQL\/AI Query Query Type<\/strong>. <\/p>\n\n\n\n

In the From table <\/strong>drop-down menu, select an SQL table from which you would like to retrieve the data (\u201cposts\u201d in this case).<\/p>\n\n\n\n

Optionally, we press the \u201cAdd new<\/strong>\u201d button in the Where (query clauses) <\/strong>to set such options:<\/p>\n\n\n\n