Hello

Well, I found out about this neat site a few days ago. Really interesting I must say.
Anyways, the problem I'm having is with the first challenge, Lesson #1 - SQL.

I did 'em all, except for 6,7, and 9. They seem broken to me.

the 6:th question : "Delete the row that has the city of San Francisco"
DELETE FROM countries WHERE city='San Francisco'

Doesn't work.


7:th : "Update all rows that contain United States as the country and set Los Angeles as the city."
UPDATE countries SET city = 'Los Angeles' WHERE country = 'United States'

Doesn't work.


9:th : " Insert a new row with the following data: Country: France, City: Paris."
INSERT INTO countries (country, city) VALUES ('France', 'Paris')

Doesn't work either, gives me the error : "That is not what we are looking for.". Then what are they looking for?

Seriously, what else options do I have? In what other way can I achieve the objectives?
As far as I know, this is the way. And its quite embarrasing as I have taken a lesson in SQL, tho on a Swedish "upper secondary school" with a straight A+ (MVG). And I've also been coding SQL among with PHP for some years now.

I must be soo newb :S

I'd really appreciate the help.

Ok, thanks :) At least it makes the effort worth something.