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'