MySQL_Narb Posted August 5, 2012 Share Posted August 5, 2012 http://www.sqlzoo.net/1a.htm I did: SELECT name,region FROM bbc WHERE region IN ((SELECT region FROM bbc WHERE name LIKE '%India%'), (SELECT region FROM bbc WHERE name LIKE '%Iran%')) Was this really the correct query? It says it is, but it just feels like there's a more simplified way. Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/ Share on other sites More sharing options...
MySQL_Narb Posted August 5, 2012 Author Share Posted August 5, 2012 Ignore the above post please. I would like for anyone that can solve this problem to help me out if they can: SELECT name,population,region FROM bbc b WHERE 25000000 > ALL(SELECT population FROM bbc x WHERE b.region=x.region) Is currently what I have, for 3b: http://www.sqlzoo.net/1a.htm Any ideas? Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/#findComment-1366920 Share on other sites More sharing options...
fenway Posted August 5, 2012 Share Posted August 5, 2012 This sounds like homework -- what are you actually trying to do? Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/#findComment-1366965 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.