When creating a new table from an SQL query. I get the below error

There was an error while trying to save the table! OK

Notice: Undefined index: table in /var/www/html/dev/wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 1638

Notice: Trying to get property 'pos' of non-object in /var/www/html/dev/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 780
{"table":{"_cacheHash":"","connection":null},"error":"Column 'pos' cannot be null"}

Tested the below SQL query in mysql and was able to generate results correctly. 

SELECT 
IFNULL(grc,'NO GRC') AS grc, 
    SUM(num_participants) as numparticipants,
    SUM(num_participants)/(SUM(SUM(num_participants)) OVER ())*100 AS pcparticipants,
    SUM(IFNULL(scj_completed,0)) AS scjcompleted,
    SUM(IFNULL(scj_not_completed,0)) AS scjnotcompleted
FROM 
(
SELECT
    grc,
COUNT(*) as num_participants,
SUM(CASE WHEN scj_status = 7 OR scj_status = 8 THEN 1 ELSE 0 END) as scj_completed, 
SUM(CASE WHEN scj_status != 7 AND scj_status != 8 THEN 1 ELSE 0 END) as scj_not_completed
FROM
wp_scj_participants
LEFT JOIN wp_scj_grcmap ON wp_scj_participants.postal_code = wp_scj_grcmap.postalcode
WHERE
scj_status IS NOT NULL
AND (1=1 OR aip_date BETWEEN '%VAR1%' AND '%VAR2%')

GROUP BY
wp_scj_grcmap.grc
) a
GROUP BY grc
ORDER BY num_participants DESC

Hi Aleksandar, 

Do you know which part of the query I provided was causing the error? From what I see the functions I used are not blocked, as I have another query with SELECT, COUNT, SUM, IFNULL. 

Noted on this, we'll try to put that in views if it becomes overly complex.