DROP TABLE corpusphonemeslist; 
SELECT phonemes, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE corpusphonemeslist FROM corpuswordlist GROUP BY phonemes;
GRANT SELECT ON celexphonemeslist TO PUBLIC;

DROP TABLE corpusmannerlist; 
SELECT manner, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE corpusmannerlist FROM corpuswordlist GROUP BY manner;
GRANT SELECT ON corpusmannerlist TO PUBLIC;

DROP TABLE corpusarticulatorlist; 
SELECT articulator, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE corpusarticulatorlist FROM corpuswordlist GROUP BY articulator;
GRANT SELECT ON corpusarticulatorlist TO PUBLIC;

DROP TABLE corpusvoicinglist; 
SELECT voicing, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE corpusvoicinglist FROM corpuswordlist GROUP BY voicing;
GRANT SELECT ON corpusvoicinglist TO PUBLIC;


DROP TABLE celexphonemeslist; 
SELECT phonemes, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE celexphonemeslist FROM celexwordlist GROUP BY phonemes;
GRANT SELECT ON celexphonemeslist TO PUBLIC;

DROP TABLE celexmannerlist; 
SELECT manner, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE celexmannerlist FROM celexwordlist GROUP BY manner;
GRANT SELECT ON celexmannerlist TO PUBLIC;

DROP TABLE celexarticulatorlist; 
SELECT articulator, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE celexarticulatorlist FROM celexwordlist GROUP BY articulator;
GRANT SELECT ON celexarticulatorlist TO PUBLIC;

DROP TABLE celexvoicinglist; 
SELECT voicing, sum(frequency) as frequency, sum(smooth) as smooth INTO TABLE celexvoicinglist FROM celexwordlist GROUP BY voicing;
GRANT SELECT ON celexvoicinglist TO PUBLIC;
