Help with Wordpress, Elementor Pro, JetEngine

Job ID: 37462802

Budget: $30 – $250 USD

I have created a Post Type where the user can enter the data through a Form (using JetFormBuilder) such

- Top (yes/no),
- Flash(yes/no), and
- Tries (integer, e.g., 1,2,3,4,...)

The information the user enters is shown in a Table (created through the Query and Tables Builder).

A user can post information on several pages.
All information the user enters is page- and user-name-specific.

I want to create a table which shows

(1) The sum of Tries as #Tries
(2) The number of cases where there is at least one Top == yes appears on a page as #Top
(3) The number of cases where there is at least one Flash == yes appears on a page as #Flash

by user-name

The resulting table should have the structure:
user-name; #Tries; #Top; #Flash

How can I achieve this?
Related categories: SQL WordPress Elementor