November 12, 2009 at 7:48 am
Thank You in advance
How are you doing ladies and gentleman.
I got few exemple queries from a buddy of mind but I don't know how make it to work so I need a help here!
The question is, What are the sql command will find every one of these queries based on the web page the link I provided at the bottom of the page...
1.Show the name and area of all countries
2.Show the name and area of all European countries
3.Show the name and area in of all European countries sorted by area from smallest to largest
4.Show the name, population, and GDP of all South American countries sorted by area from largest to smallest
5.Show all name and population density (person/area) of Asian countries
6.Show the name of all countries that begin with the letter S
based on this data base
November 12, 2009 at 8:07 am
This looks like homework. Is it?
Give it a try yourself, if you get stuck, show us what you've done and where you're stuck and we can help.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2009 at 8:18 am
I found 1,6 but the rest of them I've been struggling in about 3 hours over the night but couldn't come up with a proper command.
but thank your quick comment though!
November 12, 2009 at 8:25 am
I have to say this is pretty cool a teacher actually took the time to build a small website for testing queries! I would have loved to learn SQL in those conditions, it's pretty straightforward, you get to see what's the result of your query, and answer the "small puzzles". I love the idea!
You really should take the time to use this tool, and follow the instructions! If we give you answers, it'll be too easy and you won't learn the syntax!
Good luck!
Cheers,
J-F
November 12, 2009 at 8:29 am
As Gail mentioned, we'd be happy to help you understand the SQL, but we'd like to see what code you've written. What don't you understand, or what is the code doing that is a problem. We can likely explain issues to you and help, but we don't want to do the work for you.
November 12, 2009 at 8:38 am
Good site as J-F Bergeron mentioned 🙂
There is no point if we help you out and you wont learn. Can give hints as in for 2a its one of the comparision operator you gotta use. Just do some research on it. Thanks
and all the best!
---------------------------------------------------------------------------------
November 12, 2009 at 9:22 am
Thank you all
I just found it... hehe I didn't know like this simple....
Have a great day you'all
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply