I have few sqlzoo query command questions

Question

Post reply

I have few sqlzoo query command questions

bruce.canyon

SSC Journeyman

Points: 87
More actions
November 12, 2009 at 7:48 am

#139446

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
http://sqlzoo.net/1.htm

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bruce.canyon SSC Journeyman Points: 87 More actions · Answer 2

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!

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 3

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

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.

Nabha SSCrazy Eights Points: 8534 More actions · Answer 5

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!

---------------------------------------------------------------------------------

bruce.canyon SSC Journeyman Points: 87 More actions · Answer 6

Thank you all

I just found it... hehe I didn't know like this simple....

Have a great day you'all