From the course: Data Analytics with Observable

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Manipulating data (SQL query)

Manipulating data (SQL query) - Observable Tutorial

From the course: Data Analytics with Observable

Start my 1-month free trial Buy for my team

Manipulating data (SQL query)

“

- [Instructor] So let's write that SQL Query and join these two tables together. So let me just quickly do that. I'm going to say select h.* and u.* and if you're familiar with SQL, this will be syntax that's familiar. If not, you can look this stuff up, and I'm going to say from happiness as h, join urbanization as u on h.CountryCode = u.CountryCode. Where, let's try this, "urbanization" <= 20. So let's try this and let's see what happens. I'm going to hit Shift + Enter. I have an error, uh-oh, table h, that's my happiness data 'cause I asked it to use that abbreviation here does not have a column named CountryCode, one word. Oh right, because it's actually, where is that one? I'm pulling from up here I think, it's actually Country Code. So I can actually rename it. Shift + Enter. Did that fix it? Oh, same problem. Table u also does not have a column named CountryCode. So let's fix that one. Hmm, oh…

Contents