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 Quote 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 Quote 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? Quote 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/ Quote Link to comment https://forums.phpfreaks.com/topic/88884-sql/#findComment-455343 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.