Databases and MySQL

Today we started Databases and MySQL. My mind is exhausted from the amount of info we learned today. I don't know how much I will be able to write. but figuring out some of these problems has been quite the challenge. It is somewhat starting to click, finally!

Here a some of the example problems we have to solve in the next 2 days:

1. What query would your run to get all Constitutional Monarchy Countries with a capital greater than 200 and of life expectancy greater than 75 years.

(This is the database we need to use to get the answer.)

This is the answer I came up with:

Use World;
SELECT * FROM Country
WHERE GovernmentForm = ("Constitutional Monarchy") and Capital > 200 and LifeExpectancy > 75;


This took about an hour to solve haha.




Looks like this ->

- Kyle