Sum() does not work where there is $ in front of the number ? (SQL)

/* Put your data in here and query it! */
/* Source: http://www.boxofficemojo.com/alltime/world/ */

CREATE TABLE top_movies(
  rank TEXT NOT NULL PRIMARY KEY
, title TEXT
, studio TEXT
, worldwide TEXT
, domestic_money TEXT
, domestic_percent TEXT
, overseas_money TEXT
, overseas_percent TEXT
, year TEXT
);
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('Rank','Title','Studio','Worldwide','Domestic / %','Overseas / %','Year^','','');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('1','Avatar','Fox','$2,788.0','$760.5','27.3%','$2,027.5','72.7%','2009^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('2','Titanic','Par.','$2,186.8','$658.7','30.1%','$1,528.1','69.9%','1997^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('3','Marvel''s The Avengers','BV','$1,518.6','$623.4','41.0%','$895.2','59.0%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('4','Harry Potter and the Deathly Hallows Part 2','WB','$1,341.5','$381.0','28.4%','$960.5','71.6%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('5','Furious 7','Uni.','$1,322.2','$321.2','24.3%','$1,001.0','75.7%','2015');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('6','Frozen','BV','$1,274.2','$400.7','31.4%','$873.5','68.6%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('7','Iron Man 3','BV','$1,215.4','$409.0','33.7%','$806.4','66.3%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('8','Transformers: Dark of the Moon','P/DW','$1,123.8','$352.4','31.4%','$771.4','68.6%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('9','The Lord of the Rings: The Return of the King','NL','$1,119.9','$377.8','33.7%','$742.1','66.3%','2003^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('10','Skyfall','Sony','$1,108.6','$304.4','27.5%','$804.2','72.5%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('11','Transformers: Age of Extinction','Par.','$1,091.4','$245.4','22.5%','$846.0','77.5%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('12','The Dark Knight Rises','WB','$1,084.4','$448.1','41.3%','$636.3','58.7%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('13','Pirates of the Caribbean: Dead Man''s Chest','BV','$1,066.2','$423.3','39.7%','$642.9','60.3%','2006');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('14','Toy Story 3','BV','$1,063.2','$415.0','39.0%','$648.2','61.0%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('15','Pirates of the Caribbean: On Stranger Tides','BV','$1,045.7','$241.1','23.1%','$804.6','76.9%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('16','Jurassic Park','Uni.','$1,029.2','$402.5','39.1%','$626.7','60.9%','1993^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('17','Star Wars: Episode I - The Phantom Menace','Fox','$1,027.0','$474.5','46.2%','$552.5','53.8%','1999^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('18','Alice in Wonderland (2010)','BV','$1,025.5','$334.2','32.6%','$691.3','67.4%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('19','The Hobbit: An Unexpected Journey','WB','$1,017.0','$303.0','29.8%','$714.0','70.2%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('20','The Dark Knight','WB','$1,004.6','$534.9','53.2%','$469.7','46.8%','2008^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('21','The Lion King','BV','$987.5','$422.8','42.8%','$564.7','57.2%','1994^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('22','Harry Potter and the Sorcerer''s Stone','WB','$974.8','$317.6','32.6%','$657.2','67.4%','2001');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('23','Despicable Me 2','Uni.','$970.8','$368.1','37.9%','$602.7','62.1%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('24','Pirates of the Caribbean: At World''s End','BV','$963.4','$309.4','32.1%','$654.0','67.9%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('25','The Hobbit: The Desolation of Smaug','WB','$960.4','$258.4','26.9%','$702.0','73.1%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('26','Harry Potter and the Deathly Hallows Part 1','WB','$960.3','$296.0','30.8%','$664.3','69.2%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('27','The Hobbit: The Battle of the Five Armies','WB','$955.1','$255.1','26.7%','$700.0','73.3%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('28','Harry Potter and the Order of the Phoenix','WB','$939.9','$292.0','31.1%','$647.9','68.9%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('29','Finding Nemo','BV','$936.7','$380.8','40.7%','$555.9','59.3%','2003^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('30','Harry Potter and the Half-Blood Prince','WB','$934.4','$302.0','32.3%','$632.5','67.7%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('31','The Lord of the Rings: The Two Towers','NL','$926.0','$342.6','37.0%','$583.5','63.0%','2002^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('32','Shrek 2','DW','$919.8','$441.2','48.0%','$478.6','52.0%','2004');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('33','Harry Potter and the Goblet of Fire','WB','$896.9','$290.0','32.3%','$606.9','67.7%','2005');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('34','Spider-Man 3','Sony','$890.9','$336.5','37.8%','$554.3','62.2%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('35','Ice Age: Dawn of the Dinosaurs','Fox','$886.7','$196.6','22.2%','$690.1','77.8%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('36','Harry Potter and the Chamber of Secrets','WB','$879.0','$262.0','29.8%','$617.0','70.2%','2002');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('37','Ice Age: Continental Drift','Fox','$877.2','$161.3','18.4%','$715.9','81.6%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('38','The Lord of the Rings: The Fellowship of the Ring','NL','$871.5','$315.5','36.2%','$556.0','63.8%','2001^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('39','The Hunger Games: Catching Fire','LGF','$864.9','$424.7','49.1%','$440.2','50.9%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('40','Star Wars: Episode III - Revenge of the Sith','Fox','$848.8','$380.3','44.8%','$468.5','55.2%','2005^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('41','Transformers: Revenge of the Fallen','P/DW','$836.3','$402.1','48.1%','$434.2','51.9%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('42','The Twilight Saga: Breaking Dawn Part 2','LG/S','$829.7','$292.3','35.2%','$537.4','64.8%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('43','Inception','WB','$825.5','$292.6','35.4%','$533.0','64.6%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('44','Spider-Man','Sony','$821.7','$403.7','49.1%','$418.0','50.9%','2002');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('45','Independence Day','Fox','$817.4','$306.2','37.5%','$511.2','62.5%','1996^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('46','Shrek the Third','P/DW','$799.0','$322.7','40.4%','$476.2','59.6%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('47','Harry Potter and the Prisoner of Azkaban','WB','$796.7','$249.5','31.3%','$547.1','68.7%','2004');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('48','E.T.: The Extra-Terrestrial','Uni.','$792.9','$435.1','54.9%','$357.8','45.1%','1982^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('49','Fast & Furious 6','Uni.','$788.7','$238.7','30.3%','$550.0','69.7%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('50','Indiana Jones and the Kingdom of the Crystal Skull','Par.','$786.6','$317.1','40.3%','$469.5','59.7%','2008');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('51','Spider-Man 2','Sony','$783.8','$373.6','47.7%','$410.2','52.3%','2004');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('52','Star Wars','Fox','$775.4','$461.0','59.5%','$314.4','40.5%','1977^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('53','Guardians of the Galaxy','BV','$774.2','$333.2','43.0%','$441.0','57.0%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('54','2012','Sony','$769.7','$166.1','21.6%','$603.6','78.4%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('55','Maleficent','BV','$758.4','$241.4','31.8%','$517.0','68.2%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('56','The Da Vinci Code','Sony','$758.2','$217.5','28.7%','$540.7','71.3%','2006');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('57','The Amazing Spider-Man','Sony','$757.9','$262.0','34.6%','$495.9','65.4%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('58','Shrek Forever After','P/DW','$752.6','$238.7','31.7%','$513.9','68.3%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('59','The Hunger Games: Mockingjay - Part 1','LGF','$752.1','$337.1','44.8%','$415.0','55.2%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('60','X-Men: Days of Future Past','Fox','$748.1','$233.9','31.3%','$514.2','68.7%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('61','Madagascar 3: Europe''s Most Wanted','P/DW','$746.9','$216.4','29.0%','$530.5','71.0%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('62','The Chronicles of Narnia: The Lion, the Witch and the Wardrobe','BV','$745.0','$291.7','39.2%','$453.3','60.8%','2005');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('63','Monsters University','BV','$743.6','$268.5','36.1%','$475.1','63.9%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('64','The Matrix Reloaded','WB','$742.1','$281.6','37.9%','$460.6','62.1%','2003');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('65','Up','BV','$731.3','$293.0','40.1%','$438.3','59.9%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('66','Gravity','WB','$716.4','$274.1','38.3%','$442.3','61.7%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('67','Captain America: The Winter Soldier','BV','$714.8','$259.8','36.3%','$455.0','63.7%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('68','The Twilight Saga: Breaking Dawn Part 1','Sum.','$712.2','$281.3','39.5%','$430.9','60.5%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('69','The Twilight Saga: New Moon','Sum.','$709.8','$296.6','41.8%','$413.2','58.2%','2009');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('70','Transformers','P/DW','$709.7','$319.2','45.0%','$390.5','55.0%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('71','The Amazing Spider-Man 2','Sony','$709.0','$202.9','28.6%','$506.1','71.4%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('72','Dawn of the Planet of the Apes','Fox','$708.8','$208.5','29.4%','$500.3','70.6%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('73','The Twilight Saga: Eclipse','Sum.','$698.5','$300.5','43.0%','$398.0','57.0%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('74','Mission: Impossible - Ghost Protocol','Par.','$694.7','$209.4','30.1%','$485.3','69.9%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('75','The Hunger Games','LGF','$691.2','$408.0','59.0%','$283.2','41.0%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('76','Forrest Gump','Par.','$677.9','$330.3','48.7%','$347.7','51.3%','1994^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('77','The Sixth Sense','BV','$672.8','$293.5','43.6%','$379.3','56.4%','1999');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('78','Interstellar','Par.','$672.7','$188.0','27.9%','$484.7','72.1%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('79','Man of Steel','WB','$668.0','$291.0','43.6%','$377.0','56.4%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('80','Kung Fu Panda 2','P/DW','$665.7','$165.2','24.8%','$500.4','75.2%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('81','Ice Age: The Meltdown','Fox','$660.9','$195.3','29.6%','$465.6','70.4%','2006');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('82','Pirates of the Caribbean: The Curse of the Black Pearl','BV','$654.3','$305.4','46.7%','$348.9','53.3%','2003');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('83','Big Hero 6','BV','$652.0','$222.4','34.1%','$429.6','65.9%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('84','Star Wars: Episode II - Attack of the Clones','Fox','$649.4','$310.7','47.8%','$338.7','52.2%','2002^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('85','Thor: The Dark World','BV','$644.8','$206.4','32.0%','$438.4','68.0%','2013');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('86','Kung Fu Panda','P/DW','$631.7','$215.4','34.1%','$416.3','65.9%','2008');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('87','The Incredibles','BV','$631.4','$261.4','41.4%','$370.0','58.6%','2004');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('88','Fast Five','Uni.','$626.1','$209.8','33.5%','$416.3','66.5%','2011');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('89','Hancock','Sony','$624.4','$227.9','36.5%','$396.4','63.5%','2008');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('90','MIB 3','Sony','$624.0','$179.0','28.7%','$445.0','71.3%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('91','Iron Man 2','Par.','$623.9','$312.4','50.1%','$311.5','49.9%','2010');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('92','Ratatouille','BV','$623.7','$206.4','33.1%','$417.3','66.9%','2007');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('93','How to Train Your Dragon 2','Fox','$618.9','$177.0','28.6%','$441.9','71.4%','2014');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('94','The Lost World: Jurassic Park','Uni.','$618.6','$229.1','37.0%','$389.6','63.0%','1997');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('95','The Passion of the Christ','NM','$611.9','$370.8','60.6%','$241.1','39.4%','2004^');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('96','Mamma Mia!','Uni.','$609.8','$144.1','23.6%','$465.7','76.4%','2008');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('97','Life of Pi','Fox','$609.0','$125.0','20.5%','$484.0','79.5%','2012');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('98','Madagascar: Escape 2 Africa','P/DW','$603.9','$180.0','29.8%','$423.9','70.2%','2008');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('99','Casino Royale','Sony','$599.0','$167.4','28.0%','$431.6','72.0%','2006');
INSERT INTO top_movies(rank,title,studio,worldwide,domestic_money,domestic_percent,overseas_money,overseas_percent,year) VALUES ('100','Tangled','BV','$591.8','$200.8','33.9%','$391.0','66.1%','2010');
SELECT * FROM top_movies;
SELECT rank, title FROM top_movies WHERE domestic_money > "$600" ;

SELECT title FROM top_movies WHERE studio = "Sony";
SELECT sum(worldwide) FROM top_movies WHERE studio = "Sony";

Simple question: I wanna know how much money Sony made worldwide.
But the sum function does not seem to work.
Is it because there is a $ in front of each number???

you can’t obtain a sum on a text field

1 Like

oh… i forgot to check the type…

Hello,
First of all, you cannot apply sum() on text type field. In case still, you want to do a sum you can perform it by following way.

E.g.  SELECT SUM(CAST(Textcolumn as int))