dhimok Posted February 1, 2008 Share Posted February 1, 2008 Hello everyone! I have this table with country_name, population and area. How do I get the density for each country with sql thanks in advance Link to comment https://forums.phpfreaks.com/topic/88884-sql/ Share on other sites More sharing options...
sasa Posted February 1, 2008 Share Posted February 1, 2008 SELECT country_name, population / area FROM table_name Link to comment https://forums.phpfreaks.com/topic/88884-sql/#findComment-455285 Share on other sites More sharing options...
dhimok Posted February 1, 2008 Author Share Posted February 1, 2008 Thank you! How can I list all countries which are in the same region/continent as India and Italy? Link to comment https://forums.phpfreaks.com/topic/88884-sql/#findComment-455332 Share on other sites More sharing options...
revraz Posted February 1, 2008 Share Posted February 1, 2008 http://www.sqlzoo.net/ Link to comment https://forums.phpfreaks.com/topic/88884-sql/#findComment-455343 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.