Custom DataBase Tables, Failed to create table

CREATE TABLE wp_cpd
(entity_id, cpd_area, cpd_year, cpd_date, cpd_name, cpd_units)
(SELECT entity_id,
CASE WHEN slug=’cpd_area’ THEN values ELSE NULL
END as cpd_area,
CASE WHEN slug=’cpd_year’ THEN values ELSE NULL
END as cpd_year,
CASE WHEN slug=’cpd_date’ THEN values ELSE NULL
END as cpd_date,
CASE WHEN slug=’cpd_name’ THEN values ELSE NULL
END as cpd_name,
CASE WHEN slug=’cpd_units’ THEN values ELSE NULL
END as cpd_units,
FROM wp_cf_form_entry_values
GROUP BY entity_id,
ORDER BY entity_id);

https://www.ads-software.com/plugins/custom-database-tables/