SQL - SQLZoo - How to do the various "Select from World" queries

Description:
How to write the various SQL Zoo queries.

The SELECT from Nobel video: https://www.youtube.com/watch?v=szOGMlfwJSE

SQL ZOO - Where to go to follow along:
SELECT Basics (1-3) https://sqlzoo.net/wiki/SELECT_basics
SELECT from world https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial

Tutorials on LIKE operator:
W3schools https://www.w3schools.com/sql/sql_like.asp
Wildcards https://www.w3schools.com/sql/sql_wildcards.asp
SQLzoo https://sqlzoo.net/wiki/SELECT_names

0:00 Intro
0:30 SELECT Basics #1
3:29 SELECT Basics #2
5:12 SELECT Basics #3 - Where area BETWEEN 200k AND 300k
6:33 SELECT from World #1
7:33 SELECT from World #2
8:05 SELECT from World #3 - Per capita GDP
10:53 SELECT from World #4 - Population in millions (also explain ALIAS)
13:22 SELECT from World #5 - WHERE name IN('France', 'Germany', 'Italy')
14:07 SELECT from World #6 - Name includes "United" (explain LIKE operator)
18:05 World #7 - Big by area or big by population (i.e. area greater than 3M)
19:19 World #8 - XOR (Exclusive OR)
22:48 World #9 - Rounding, i.e. ROUND(population/1000000,2)
25:00 World #10 - Trillion dollar countries (round to nearest $1000).
27:34 World #11 - Name and capital have same length i.e. LENGTH(name) = LENGTH(capital)
31:34 World #12 - Show the name and the capital where the first letters of each match. (So LEFT(name,1) = LEFT(capital,1)
34:21 World #13 - Find the countries that have all of the vowels (a e i o u) in their name.







*********************************************************
#sql #queries #database #mysql #sqlzoo