CREATE TABLE channel (Share_in_percent INT, OWNER VARCHAR)

find the total percentage share of all channels owned by CCTV.
SELECT SUM(Share_in_percent) FROM channel WHERE OWNER = 'CCTV'
SELECT SUM("Share_in_percent") FROM "channel" WHERE "OWNER" = 'CCTV'