2016.10.27 Chinese Lesson

单词：
1.自己[zì jǐ] :  by myself
   例句：我自己学习汉语。
       wǒ zì jǐ xué xí hàn yǔ 。



2.学校[xué  xiào] : school
   例句：我的学校交换学生的项目。
     wǒ de xué xiào jiāo huàn xué shēng de xiàng mù 。



3.公司职员[Gōng sī zhí yuán]: salary man/woman
         例句：我是 公司职员。
          wǒ shì  gōng sī zhí yuán 。



4.自我介绍[zì wǒ jièshào] : Let me introduce myself.
      例句：我来自我介绍一下。
          wǒ lái zì wǒ jiè shào yí xià 。


句子：
1.我工作了。wǒ gōng zuò le 。
I'm working.
2.我最近不忙，但是以前很忙。wǒ zuì jìn bù máng ，dàn shì yǐ qián hěn máng 。
I'm not busy nowadays, but I used to be busy before.
3.我免贵姓王。wǒ miǎn guì xìng wáng 。
[polite form] My surname is Wang.
4.你多大？nǐ duō dà ？
How old are you?
5.你几岁？nǐ jǐ suì ？
[To kids under 10]: How old are you?
6.请多多关照。qǐng duō duō guān zhào 。
[Meeting someone for the first time] Please be good to me.

2016.10.28 Chinese Lesson

单词：
１.同岁 [tóng suì]: same age
    例句：我的爸爸和妈妈是同岁。
　　　　wǒ de bà ba hé mā ａ shì tóng suì 。

２.校长[xiào zhǎng] : principal
    例句：我们的校长很好。


３.爱好[ài hào] : hobby
    例句：我的爱好是看韩剧。
　　　　wǒ de ài hào shì kàn hán jù 。


4.演技[yǎn jì]:  performance/acting
　例句：听我的朋友说，IU的演技不好。
　　　tīng wǒ de péng yǒu shuō ，IU de yǎn jì bù hǎo 。


5.前几天[qián　jǐ　tiān] : few days ago
　 　例句：前几天，我看了ｗ。
　　　　　qián jǐ tiān ，wǒ kàn le ｗ。

6. 项目[xiàngmù] ： project/ program

7. 回答 [huídá]  : answer

8. 父母 [fùmǔ] : parents

9. 读 [dú] : read

10. 泛音 [fànyīn] : pronunciation

11. 周末 [zhōumò] : weekend

12. 愉快的 [yúkuàide] : pleasant

13. 有趣 [yǒuqù] : fun


句子：
１.您今年多大年纪？[nín jīn nián duō dà nián jì ] :
[polite form  to older people] how old are you?
２.听起来，您的声音很好听。[tīng qǐ lái ，nín de shēng yīn hěn hǎo tīng ]
From what I heard, your pronunciation is good.
３.这家饭店来了很多客人。[zhè jiā fàn diàn lái le hěn duō kè rén]
That restaurant has a lot of customers.

[Basic Chinese - 11] 没有／是～吗？ ／ 不是～吗？／了 ／ 还没／ 过

没有 ： don't have
你没有钱吗？［nǐ méiyǒu qián ma］：Don't you have money?
我没有钱。［wǒ méiyǒu qián］：I don't have money.

你没有怒朋友吗？［nǐ méiyǒu nǚpéngyou ma］：Don't  you have a girlfriend?
我没有怒朋友。［wǒ méiyǒu nǚpéngyou］: I don't have a girlfriend.

没有积分卡吗？［nǐ méiyǒu jīfēnkǎ ma］：Don't you have a membership card?
我没有积分卡。［wǒ méiyǒu jīfēnkǎ］：I don't have a membership card.
积分卡 ： membership card
－－－－－－－－－－－－－－－－－－－－－－－－－－－
是～吗？ ： is it?

他是新生吗？［tā shì xīnshēng ma］：isn't he a newbie?
他是新生。［tā shì xīnshēng］：yes, he is.

他是老大吗？［tā shì lǎodà ma］：is he a first born child?
他是老大。［tā shì lǎodà］：he is a first born child.

他是高手吗？［tā shì gāoshǒu ma］：is he a craftsman?
他是高手。［tā shì gāoshǒu］: he is a craftsman.
－－－－－－－－－－－－－－－－－－－－－－－－－－－
不是～吗？ ： isn't it?

他不是单身吗？［tā búshì dānshēn ma］：isn't he single?
他不是单身。［tā búshì dānshēn］：he is not a single.
单身： single

他不是新手吗？［tā búshì xīnshǒu ma］：isn't he an amateur?
他不是新手。［tā búshì xīnshǒu ma］：he is not an amateur.
新手 ： amateur

她不是校花吗？［tā  búshì xiàohuā ma］：isn't she a hot girl at school?
她不校花话。[tā  búshì xiàohuā]：she is not.
校花 ： popular girl at school

－－－－－－－－－－－－－－－－－－－－－－－－－－－
了 ：the state of an action being completed

你定了吗？［nǐ  dìng le ma］：have you decided?
还没定。［hái méi  dìng］：not yet decided.
定 ： decide

你吃了吗？［nǐ chī le ma］：have you eaten?
还没吃。［hái méi chī ］：not yet.

你存了吗？［nǐ cún le ma］：have you transferred money?
还没存。［hái méi cún ］：not yet.
存 ： transfer money
－－－－－－－－－－－－－－－－－－－－－－－－－－－
过 ： ～having the experience of ...

你看过吗？［nǐ kànguo ma］：have you seen?
看过。［kànguo］：have seen it.
看： see

你学过吗？［nǐ xuéguo ma］：have you studied?
学过。［xuéguo］：have studied it.
学： study

你用过吗？［nǐ yòngguo ma］：have you used it?
用过。［yòngguo］：have used it.
用 ： use

[basic chinese - 10] 别／没／有

别 ： don't
没 ： not

你别哭。［nǐ bié kū］： Do not cry.
我没哭。［wǒ méi kū］： I'm not crying.

你别笑。［nǐ bié xiào］：Do not laugh.
我没笑。［wǒ méi xiào］：I'm not laughing.

你别生气。［nǐ bié shēngqì］：Do not be angry.
我没生气。［wǒ méi shēngqì］：I'm not angry.

-----------------------------------------------------
有 ： have

你有充电器吗？［nǐ yǒu chōngdiànqì ma］：Do you have a charger?
我有充电器。［wǒ yǒu chōngdiànqì］： I do have charger.

你有充电宝吗？［nǐ yǒu ěrjī ma］：Do you have a portable charger?
我有充电宝。［wǒ yǒu ěrjī］：I do have a portable charger.

你有耳机吗？［nǐ yǒu chōngdiànbǎo ma］：Do you have an earphone?
我有耳机。［wǒ yǒu chōngdiànbǎo］: I do have an earphone.

[Basic Chinese - 9] 明天星期几? / 一共多少钱？

明天星期几？［míngtiān xīngqī jǐ］：which day is it tomorrow?
明天星期一。［míngtiān xīngqīyī］：Tomorrow is Monday.

今天星期几？［jīntiān xīngqī jǐ］：Which day is it today?
今天星期天。［jīntiān xīngqītiān］：Today is Sunday.

后天星期几？［hòutiān xīngqī jǐ］：Which day is it the day after tomorrow?
后天星期儿。［hòutiān xīngqī'èr］：The day after tomorrow is Tuesday.
后天： the day after tomorrow

星期一： Monday
星期二： Tuesday
星期三： Wednesday
星期四：Thursday
星期五： Friday
星期六：Saturday
星期天：Sunday

星期：days
星期几：which day

-----------------------------------------

一共多少钱？［yígòng duǒshao qián］：How much are they altogether?
六十块。［liùshí kuài］：40 yuan.
一共 ： altogether/everything

那个多少钱？［náge duōshao qián］: How much is that?
三十块。［sānshí kuài］：30 yuan.
那个：that thing
这个：this thing

一个多少钱？［yí ge duōshao qián］：How much is this for one piece?
二十块。［èrshí kuài］：20 yuan.
个： count for  piece/person

元［yuán］: 块 is for conversational language; 元 is for written language

[Basic Chinese - 7] 可以坐吗？/ 他去哪？/他也看吗？

可以 ［kěyǐ］ ： can

可以坐吗？［ kěyǐ zuò ma］ : can you sit?

可以坐。［kěyǐ zuò］ : Can sit.

可以用吗？ ［kěyǐ yang ma］: Can you use?

可以用。［kěyǐ yòng］:  Can use.

可以喝吗？［kěyǐ hē ma］ :  Can you drink?

可以喝。［kěyǐ hē］:  Can drink.

去哪？［qùnǎr］ ： Where to go?

--------------------------------------------

他去哪？［tā qù nǎr］: Where is he going?

他去银行。［tā qù yínháng］:  He's going to the bank.

你去哪？［nǐ qù nǎr］ : Where are you going?

我去易买得。［wǒ qù yìmǎidé］: I'm going to emart.

她去那？［tā qù nǎr］: Where is she going?

她去地铁站。［tā qù dìtiězhàn］: She's going to the subway station.

--------------------------------------------

也［yě］ ： also

他也看吗？ ［tā yě kànma］：Is he also watch it?

他也看。［tā yě kàn］：He watches too.

他也听吗？ ［tā yě tīngma］：Is he listening too?

他也听。［tā yě tīng］：He listens too.

他也来吗？ ［tā yě láima］：Is he also gonna come?

他也来。［tā yě  lái］： He's gonna come too.

[Basic Chinese - 8] 你们都去吗?/这是谁的？/衣服怎么样？/几点结束？

你们都去吗［nǐmen dōu qù ma］？：Are you guys all going?
我们都去。［wǒmen dōu qù]：We are all going.

他们都去吗？［tāmen dōu qù ma］：Are they all going?
 他们都去。［tāmen dōu qù］：They are all going.

大家都去吗？［dàjiā dōu qù ma］：Is everyone going?
大家都去。［dàjiā dōu qù］：Everyone is going.

------------------------------------------------
这是谁的？［zhè shì shéi de］：Whose is this?
这是我的。［zhè shì wǒ de］：This is mine.
这： this

那是谁的？［nà shì shéi de］：Whose is that?
那是我的。［nà shì wǒ de］： That is his.
哪： that

它是谁的？［tā shì shéi de］：Whose is this/that?
它是我的。［tā shì xiǎolóng de］：This/that is mine.
它 ： this or that for non-living things

------------------------------------------------
衣服怎么样？［yīfu zěnmeyàng］：How's the clothes?
很好看。［hěn hǎokàn］：It's very pretty.
衣服： clothes
怎么样： how about...?

最近怎么样？［zuìjìn zěnmeyàng］： How are you nowadays?
很好。［hěn hǎo］： Really good.
最近 ： lately/nowadays

味道怎么样？［wèidao zěnmeyàng］：How's the taste?
很不错。［hěn búcuò］：Very good.

不错 : fine/ good


------------------------------------------------
几点结束？［jǐ diǎn jiéshù］：What time does it finish?
九点结束。［jiǔ diǎn jiéshù］：It starts at 9.
结束： finish

几点开始？［jǐ diǎn kāishǐ］：What time does it start?
八点开始。［bā diǎn kāishǐ］：It finishes at 8.
开始: start

几点出发？［jǐ diǎn chūfā］：What time does it depart?
十点出发。［shí diǎn chūfā］： It departs at 10.
出发： depart

[Becoming Ebay Summit, Fall 2016] Thoughts & Lessons

I've recently entered ebay and there was Becoming Ebay Summit this week for three days.
In order to memorize what I've learnt from the summit,
I'm going to write down some thoughts and lessons I've learnt and felt.

[Closing session : Brian Byun, country manager of eBay Korea]
The closing lesson was from the country manager of South Korea, Brian Byun.
He told us three lessons to remember.
1) We gotta remember the purpose of our company.
Ebay is not a company that sells products, but a company that sells customer experience.

2) We gotta keep on improving ourselves. Constantly bettering ourselves.
-> This is something that really hit me hard. Ever since I've entered the company in May 2016, I've been slacking off in learning new things and improving myself.
My boyfriend is studying really hard to move to a better position, but I was very content with my current position that I slacked off in improving myself. I didn't have a strong motivation to improve myself.

Yet, in order to become a 'dream person' that I want to be, I gotta be different from others!
I gotta keep on trying to be a better person tomorrow than today....
Hmm.. it does sound a bit difficult. But fortunately, my company offers a really good work-and-life balance. I go to work at 8:30am and finish work at 5:30pm. Unless there are crucial errors, I barely overwork. This is great. I gotta really make use of my past time to the fullest! Let's try this. I don't wanna be one of the other ordinary people.... !!

3) Write down your worries in every half year.
He told us that it helped him to look at his worries constantly and it motivated him to actively take efforts to resolve those worries.. !
This is the reason why I'm constantly trying to write things down in my blog. I do not want to pass by a day without any thoughts. I wanna jot down notes for future reference. Let's do this!

*Everyone's life is a treasure.
We all have to value our lives.
What kind of jewel our life is gonna be in the end depends on how well we live our days everyday


[PIC : Product Innovation Center]
A new PIC head just came to Korea recently, and her talk was interesting!
She has an amazing career and I'd like to become a woman leader like her when I am about her age..!
There were a few things she wanted to build now that she's the head of PIC:
1) THINKER-DOER-MAKER
Let people 'think' more and by asking questions - 'Why do we have to do this?'
2) Communication
Better communication among product managers, developers and designers

[Tips for career]
1. Be yourself
2. Priority Setting
-> set your long-term career direction; You gotta have a long-term goal and constantly improve yourself by trying out and learning new things!
-> Set a role model and have a network of mentors around you(leaders/managers)

* Be oriented to consumers, listen to their voice/needs, Think like a consumer! 

[SQL Intermdiate] Aggregate Functions - Part2

*DISTINCT
SELECT DISTINCT enables you to find the unique values in a particular column.

SELECT DISTINCT month
FROM table1

SELECT DISTINCT year, month
FROM table1

-> DISTINCT with COUNT
SELECT COUNT(DISTINCT month) AS unique_months
FROM table1

*CASE
-SQL case statement : if/then logic
-it must end with 'END' statement

SELECT player_name, year,
CASE WHEN year = 'SR' THEN 'yes'
            ELSE NULL END AS is_a_senior
FROM benn.college_football_players

*JOIN
Joining two tables and finding data from two tables with one query
-> Join is incredibly useful because keeping all the data in one table is impossible.

-> Aliases in SQL

SELECT teams.conference as conference,
AVG(players.weight) AS average_weight,
FROM table1 teams -- alias
JOIN table2 palayers -- alias
ON teams.school_name = players.school_name --  school_name is a column that is common in both                                                                                      tables : mappings
GROUP BY teams.conference
ORDER BY AVG(players.weight) DESC

ON teams.school_name = players.school_name
means
Join all rows from the players table on to rows in the teams table for which the school_name field in the players table is equal to the school_name field in the teams table.

SELECT *
FROM table1 players
JOIN table2 teams
ON teams.school_name = players.school_name

-> returns all the columns from both tables
-> If you want to return columns from one table, write
SELECT players.*

*INNER JOIN
- Multiple columns in one table with the same name
- Inner joins eliminate rows from both tables that do not satisfy the join condition set forth in the ON statement.
- Inner join is the intersection of the two tables

- Only find the shared values in both tables

SELECT players.*, teams.*,
FROM table1 players
JOIN table2 teams
ON teams.school_name = players.school_name
=> the results will simply show the exact same result set for both columns even it the two columns should contain different data

SELECT players.school_name AS players_school_name,
teams.school_name AS teams_school_name
FROM table1 players
JOIN table2 teams
ON teams.school_name = players.school_name
=> If you name two columns individually, two columns will be independent.

*OUTER JOIN
- In inner join, rows from either table that are unmatched in the other table are not returned.
- In outre join, unmatched rows in either table is returned.
1) LEFT JOIN : returns only unmatched rows from the left table
2) RIGHT JOIN : returns only unmatched rows from the right table
3) FULL OUTER JOIN : unmatched rows from both tables

-> Outer join is rarely used because switching
FROM table1
LEFT JOIN table2

produces the same result as below

FROM table2
LEFT JOIN table1

->LEFT JOIN and RIGHT JOIN can be written as LEFT OUTER JOIN and RIGHT OUTER JOIN respectively

* JOINS USING WHERE OR ON

SELECT companies.permalink AS companies_permalink,
acquisitions.company_permalink AS acquisitions_permalink
FROM table1 companies
LEFT JOIN table2 acquisitions
ON companies.permalink = acquisitions.company_permalink
AND acquisitions.company_permalink != '/company/1000memories'
ORDER BY 1

- AND works the same as WHERE in JOIN statement

[SQL Intermediate] Aggregate Functions - PART 1

* Count

1) counting all rows

SELECT COUNT(*)

FROM table1

-> count(1) is the same as count(*)

2) counting individual columns

SELECT COUNT(high)

FROM table1

: only counts the values in column 'high'

3) counting non-numerical columns

SELECT COUNT(date)

FROM table1

-> using 'as' 

SELECT COUNT(date) AS count_of_date

FROM table1

-> if there's a space then use double quotes

SELECT COUNT(date) as "count of date"

FROM table1

* SUM

SELECT SUM(volume)

FROM table1

In 'SUM', it treats null values as 0. 

*MIN/MAX

SELECT MIN(volume) AS min_volume,

SELECT MAX(volume) AS max_volume

FROM table1

*AVG

SELECT AVG(high)

FROM table1

WHERE high IS NOT NULL

*GROUP BY

- Allows to separate table into different groups

SELECT  year, 

        month,

        sum(volume)

from table1

group by month, year

order by year, month

-> using GROUP BY with ORDER BY 

the data is displayed chronologically

*HAVING

Having is a "clean" way to filter a query that has been aggregated. This is commonly done in a subquery. 

select year, month, max(high) as month_high

from tutorial.aapl_historical_stock_price 

group by year, month

having max(high)>450

order by year, month

Query Clause Order

1. SELECT

2. FROM

3. WHERE

4. GROUP BY

5. HAVING

6. ORDER BY

[SQL BASIC] Logical Operations

* like : allows you to match on similar values rather than exact ones.

SELECT *
  FROM table1
  WHERE "group" LIKE 'Snoop%'

% (wildcard) : finds anything that contains the word before or after
"group" is in double quotation because GROUP is actually one of the functions in SQL.
-> duble quotes indicate that you are referring to the column name "group", rather than the function itself.

*ILIKE : not case-sensitive and let you find everything that contains the same letters

SELECT*
  FROM table1
  WHERE "group" ILIKE 'snoop%'

SELECT *
  FROM table1
  WHERE artist ILIKE 'dr_ _ ke'

_ (a single underscore) : substitute for an individual character

*IN : specify a list of values that you'd like to include in the results

SELECT *
  FROM table1
  WHERE year_rank IN (1,2,3)

SELECT *
  FROM table1
  WHERE artist IN ('Taylor swift', 'Usher', 'EXO')

* BETWEEN : Select only rows that are within a specific range

SELECT *
  FROM table1
  WHERE year_rank BETWEEN 5 AND 10

----above query is the same as below ---

SELECT *
  FROM table1
  WHERE year_rank>=5 AND year_rank <=10

* IS NULL : allows you to exclude rows with missing data from your results

SELECT *
  FROM table1
  WHERE artist IS null

! important ! : WHERE artist = NULL does not work - you can't perform arithmetic on null values

* AND : select only rows that satisfy two conditions

SELECT *
  FROM table1
  WHERE year=2012 AND year_rank<=10

SELECT *
  FROM table1
  WHERE itemno = '102348'
  AND "group" ILIKE '%fear%'

*OR : select rows that satisfy either of two conditions
SELECT *
  FROM table1
  WHERE year_rank=5 OR artist='Gotye'

*NOT : select items NOT satisfying the given condition

SELECT *
 FROM table1
 WHERE year = 2013
 AND year_rank NOT BETWEEN 2 AND 3

* ORDER BY : reorder your results based in one or more columns

SELECT *
  FROM table1
ORDER BY artist
--> order artist names in A-Z( asc by default)

SELECT *
  FROM table1
  WHERE year = 2013
  ORDER BY year_rank

SELECT *
  FROM table1
  WHERE year = 2013
  ORDER BY year_rank DESC

* ORDER BY for multiple columns

SELECT *
 FROM table1
 WHERE year = 2010
 ORDER BY year_rank, artist ASC

* COMMENT IN OUT using '--' for one sentence ; /* this is comment */ for multiple lines

[Movie Review] Bridget Jones S Diary & The Edge of Reason

The 3rd movie of Bridget Jones series, 'Bridget Jones and the Baby' was out recently.
I haven't got to watch the latest Bridget Jones movie,
but the new movie reminded me of the last 2 series that are 'Bridget Jones S Diary' & 'Bridget Jones  - The Edge of Reason. '

I watched the first movie when I was in my elementary school! Wow, time flows!
The first movie was out in 2001. When I watched the movie in my elementary school years, I wasn't impressed by the movie at all. Perhaps I was too young to understand the subtle exchange of feelings among the characters in the movie and the movie didn't leave any lessons for me.  Yet, when I watched the movie again yesterday, I became a big fan of Birdget and Mark Darcy.  I could finally understand why there are so many fans of Bridget Jones and why it became such a big hit!

Bridget is a single woman in her 30s who lives in London by herself. She is eager to meet her half. Hugh Grant is a boss Bridget meets in her publishing company and they end up being in a relationship. Hugh is handsome and funny and has a great voice. Bridget falls for him and believes that Hugh is her 'meant-to-be'. However, he turns out to be cheating on Bridget and they break up.

Mark comes along around then, telling Birdget that 'I like you very much, just the way you are.' No woman would not fall for that, right? Mark and Birdget used to play in Mark's pool naked when they were 8 and 4-year old, respectively. Daniel Cleaver(Hugh Grant) were cheating on Mark's wife and they got a divorce due to that. Bridget finally has the happy ending with Mark Darcy in the end.

These two movies made me laugh a lot. How bridget said, acted were all very hilarious and fun!
Now the third movie is out, and it's 15 years after the first movie, Renee Zellweger(Bridget Jones) is a lot older than when she was in her first Bridget Jones movie.

I'm looking forward to watching the new movie!