Table schema:
CREATE TABLE channel (Share_in_percent INTEGER, OWNER VARCHAR)

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