SQL Syntax Errors
Select
case_id
case_resolve_date_utc
site_name
from schema.table;
Select
case_id
, case_resolve_date_utc
, site_name
from schema.table;
Leaders operate at all levels, stay connected to the details, audit frequently, and are skeptical when metrics and anecdote differ. No task is beneath them.
Dive Deep
What continent does the Andes Mountain range reside.
South America
What does "SQL" stand for?
Structured Query Language
Lake Union
Select rsvp_poll_date_utc,
sum(case when response_value = 'Y' then 1 else 0 end) as HMD_Y,
sum(case when response_value = 'N' then 1 else 0 end) as HMD_N
From schema.table;
Select rsvp_poll_date_utc,
sum(case when response_value = 'Y' then 1 else 0 end) as HMD_Y,
sum(case when response_value = 'N' then 1 else 0 end) as HMD_N
From schema.table
Group by 1;
Leaders start with the customer and work backwards.
Customer Obsession
The Andes Mountains run through seven countries. Name two of them.
This statistical measure describes the variability or dispersion of a dataset.
standard deviation
This American singer and actor is known for hits like "Cry Me a River".
Justin Timberlake
Select rsvp_poll_date_utc,
sum(case when response_value = 'Y' then 1 else 0) as HMD_Y,
sum(case when response_value = 'N' then 1 else 0) as HMD_N
From schema.table
Group by 1;
Select rsvp_poll_date_utc,
sum(case when response_value = 'Y' then 1 else 0 end) as HMD_Y,
sum(case when response_value = 'N' then 1 else 0 end) as HMD_N
From schema.table
Group by 1;
Many decisions and actions are reversible and do not need extensive study.
Bias for Action
This country in South America is home to the highest peak in the Andes, Mount Aconcagua.
Argentina
Why do most numbers dislike being averaged?
Because it's so 'mean' to them!
This is the largest saltwater lake in the world by surface area
Caspian Sea
With table as (
Select * from schema.table where case_id = 1
),
Select case_id from table group by 1;
With table as (
Select * from schema.table where case_id = 1
)
Select case_id from table group by 1;
...Leaders are continually raising the bar and drive their teams to deliver high quality products...
Insist on the Highest Standards
This relative of the camel is native to the Andes.
Llamas
This form of data refers to information that does not have a predefined data model or organization.
Unstructured Data
This famous ballet composed by Pyotr Ilyich Tchaikovsky tells the story of Princess Odette and Prince Siegfried.
Swan Lake
Select case_id, to_char(case_resolve_date_utc, 'YYYY "W"eek WW) as Week,
from schema.table
where case_id = 1;
Select case_id, to_char(case_resolve_date_utc, 'YYYY "W"eek WW) as Week
from schema.table
where case_id = 1;
We started in a garage...
Success and Scale Bring Broad Responsibility
This South American capital sits at an elevation of approximately 3,650 meters (11,975 feet) above sea level, and is the highest capital city in South America.
La Paz
This principle states that roughly 80% of the effects come from 20% of the causes.
Pareto Principle
This is the deepest fresh water lake in the world
Lake Baikal