2016/12/28 Chinese Lesson

晚上好~

单词

1常常 chángcháng : always/ all the time

2加班 jiābān : work overtime

3难过 nánguò : difficult to live on/ terrible

4担心 dānxīn : worried

5生气 shēngqì : angry

6紧张 jǐnzhāng : nervous

句子

1今天比昨天冷一点。

2北京没有上海人多。

3外地人[wàidìrén]：北京和上海外地人很多。

4爷爷胖还是奶奶胖？

5做考试的时候很紧张===》考试[kǎoshì]的时候很紧张[jǐnzhāng]（o）


辛苦了~ 明天见

2016/12/27 Chinese Lesson

晚上好~

单词

1洗碗 xǐwǎn : wash dishes

2歌手 gēshǒu : singer

3天气预报 tiānqìyùbào : weather forecast

4堆雪人 duīxuěrén : make a snowman
5贵 guì 비싸다

句子

1有的人喜欢看电影，有的人喜欢看电视剧。

2她比我有点胖==》她比我胖（o)

3韩国人没有中国人大===》韩国人没有中国人多（o）

辛苦了~ 明天见

2016/12/26 Chinese Class

晚上好~

单词

1火锅 huǒguō  : shabu shabu

2香菜 xiāngcài: cilantro

3全球变暖 quánqiúbiànnuǎn : global warming

4葱 cōng : spring onion/ green onion

句子

1你喝咖啡还是喝茶？

2今年比去年暖和。

3有的人喜欢吃香菜，有的人不喜欢。

4下次我们一起看电影吧！

5鸳鸯锅[yuānyāngguō] : 원앙새 솥 for shabu shabu


辛苦了~ 明天见

2016/12/22 Chinese Lesson

晚上好~

单词

1 流行音乐 liúxíngyīnyuè : popular music

2演员 yǎnyuán : actor

3果汁 guǒzhī : juice

4闹钟 nàozhōng : morning call/ alarm

5照片 [zhàopiàn] : picture/photo

6小说 [xiǎoshuō] : novel

7苦 [kǔ] : bitter

8尝 [cháng] : try something out

9起床 [qǐchuáng] : wake up

10老板 [lǎobǎn] : owner of the company

11生病 [shēngbìng] : have a disease

12酒店 [jiǔdiàn]  : hotel/accomodation

13圣诞节 [shèngdànjié]  ： christmas

句子

1我一边喝咖啡，一边上网[shàngwǎng]。

2我喜欢看爱情小说[àiqíngxiǎoshuō]。

3最近韩国经常[jīngcháng]下雨。

4我今天起床[qǐchuáng]晚了。

辛苦了~ 周末愉快

2016/12/21 Chinese Lesson

晚上好~

单词

1冬至 dōngzhì 동지

2 饺子 jiǎozi : dumpling

3红豆粥 hóngdòuzhōu : 팥죽

4手机 shǒujī : cellphone

5蛋糕 dàngāo : cake

6外套 wàitào : outer clothes

7高跟鞋 gāogēnxié : stiletto heels


句子

1需要一个时间===》需要一个小时（o）

2下了很大得雨。

3他穿什么号的合适？

4一顶帽子[yìdǐng màozi]]

5穿帽子===》戴[dài ]帽子（o）

6男朋友很短===》男朋友很矮 [ǎi]（o）

辛苦了~ 明天见

2016/12/20 Chinese Lesson

单词

1讲价 jiǎngjià : making price cheaper

2打架 dǎjià : fight

3雾霾 wùmái : smog

4抽烟 chōuyān : smoke a ciagarette

5裤子 kùzi : pants

句子

1请问，可以试穿吗？

2我旅行中国的时候===》我去中国的旅行的时候（o）

3这可以抽烟吗？

4小孩不可以打架。

辛苦了~ 明天见

2016/12/16 Chinese Lesson

晚上好~

单词

1快点 kuàidiǎn : quickly

2见面 jiànmiàn : meet

3香水 xiāngshuǐ : perfume

4便宜 piányi : cheap

5尺寸 chǐcun  : size

6百货商店 [bǎihuòshāngdiàn] : department store

7加拿大 [Jiānádà] : Canada

8预习 [yùxí] : study in advance

9黑色 [hēisè] : black

10蓝色 [lánsè] : blue

11正合适 [zhènghéshì]  : fits well


句子

1去火车站接朋友。

2可以试穿[shìchuān]吗？

3今天有一点冷。

辛苦了~ 周末愉快

2016/12/15 Chinese Lesson

晚上好~

 单词

1充足 chōngzú : enough

2大麦茶 dàmàichá : barley tea

3乌龙茶 wūlóngchá : Oolong tea

4茶道 chádào : tea ceremony

5茶壶 cháhú : tea kettle

6 银行 [yínháng] : bank

7品茶 [pǐnchá] : tasting tea

8节日 [jiérì] : anniversary

9 故乡 [gùxiāng] : hometown

10造句 [zàojù] : make a sentence

11比较 [bǐjiào] : compared to

12香 [xiāng] : smells good

13 味道 [wèidao] : taste

14皮肤 [pífū] : skin

15文化 [wénhuà] : culture
句子

1中国春节的时候休息7天。

2首尔有少人===》首尔[Shǒu'ěr] 人很少（o)

3我要每天复习汉语。

4喂，是学校宿舍吗？

5首尔住在的人没有宿舍===》住在首尔的人没有宿舍（o）


辛苦了~ 明天见

2016/12/14 Chinese Lesson

晚上好~

单词

1打的 dǎdī : take a cab

2公司 gōngsī : company

3火车站 huǒchēzhàn : train station

4门口 ménkǒu : entrance

5决定 juédìng : decide

6水源 shuǐyuán : Suwon

7联系 [liánxì] : have a contact

8接电话 [jiēdiànhuà] : answer the phone

9化妆 [huàzhuāng] : do a make-up

10陪 [péi] : treat someone well

11课文 [kèwén] : main text

12补习班 [bǔxíbān] : academy

13 上班 [shàngbān] : commute to work

14 星巴克 [xīngbākè]   : Starbucks

15 种 [zhǒng] : type

16 可能 [kěnéng] : maybe/ probably/can


句子

1我要一辆[liàng]出租汽车。

2我很喜欢吃面包。

辛苦了~ 明天见

2016/12/13 Chinese Lesson

晚上好~

单词

1包子 bāozi 찐빵. 바오쯔

2馅饼 xiànbǐng 파이

3摩天轮 mótiānlún 대관람차

句子

1这里的冬天6个月。

2最近春天很短，一个星期左右。

3春天也秋天===》春天和秋天（o）

4我学习过天津一个月===》我在天津学习过一个月（o）

5天津眼

6一条裤子  一条裙子  一件衣服



辛苦了~ 明天见

2016/12/09 Chinese Lesson

1新娘 xīnniáng : bride

2上午 shàngwǔ : morning/noon

3毕业 bìyè  : graduate

4爬山 páshān : climb mountain

5骑马 qímǎ : ride horse

6水果 shuǐguǒ : fruit

7火龙果 huǒlóngguǒ : dragon fruit

8芒果 mángguǒ : mango

9零下 [língxià] : below 0 degree

10零上 [língshàng]  : above 0 degree

11结婚仪式 [jiéhūnyíshì]  : marriage

12摩托车 [mótuōchē] : motorcycle

13超市 [chāoshì] : market

句子

1我这今天零下20度。

2在中国寒假，暑假，休息45天。

3我美国在的时候===》我在美国的时候（o）

4这么多水果。

辛苦了~ 周末愉快

2016/12/08 Chinese Lesson

晚上好~

单词

1去世 qùshì 돌아가다. 세상을 뜨다

2结婚 jiéhūn 결혼하다.

3厨房 chúfáng 주방

4故乡  gùxiāng 고향.

5下午 xiàwǔ  오후

6拍照片 pāizhàopiàn 사진을 찍다

句子

1每年春节的时候都回家过年。

2做雪人===》堆[duī]雪人（o）

辛苦了~ 明天见

2016/12/07 Chinese Lesson

单词

1虾 xiā : shrimp

2暑假 shǔjià : summer vacation

3拜年 bàinián : the act of bowing during New Year Holiday

4压岁钱 yāsuìqián : pocket money after bowing

5洗手 xǐshǒu : wash hands


句子

1他不在家，他已经出去了。

2下个周末去电影院看电影。

3我们快进教室[jiàoshì]去吧。

4打算什么时候结婚？

5中国人多少岁结婚？

6丁克族[[dīngkèzú]：不要孩子的人

辛苦了~ 明天见

2016/12/06 Chinese Lesson

1运气 yùnqi  : fortunate

2带 dài : bring someone to somewhere

3邮局 yóujú : post office

4可爱 kě'ài : cute

5旅行 lǚxíng : travel

6海鲜 hǎixiān : seafood

7螃蟹 pángxiè : crab

8少 [shǎo] : small

9反义词 [fǎnyìcí] : acronym

10微笑 [wēixiào] : smile

11笑话 [xiàohua] : funny story

12太阳 [tàiyáng] : sun

13后裔 [hòuyì] : offspring

14如果 [rúguǒ] : if

15女孩儿 [nǚháir] ： girl

16 东南西北 [dōngnánxīběi] : east, west, south, north

17马路 [mǎlù] : road

18星巴克 [xīngbākè] : Starbucks

19麦当劳 [Màidāngláo] : McDonalds

20丁字 路口 [ dīngzì lùkǒu] : three-way intersection

21日记 [rìjì] ： diary

22延期 [yánqī] ： delay
句子

1我带你去吧！



2如果他们有小时===》如果他们有时间（o）



3你到十字路口往左拐。



4去南大门怎么走？



5绿灯亮的时候，你可以走。



6马路上有人行横道。



7我在天桥上见他。



8中国重男轻女。

9做饺子===》包饺子（o）


辛苦了~ 明天见

2016/12/05 Chinese Lesson

1故宫 Gùgōng  : old palace

2路人 lùrén : stranger

3气氛 qìfēn : atmosphere

4开会 kāihuì : have a meeting

5地铁站 dìtiězhàn : subway station

6礼品 [lǐpǐn] : gift

7需要 [xūyào] : [v]need

8铜色的 [tóngsède] : bronze color

句子

1我也去颐和园，你跟我一起走吧！

2往后走 <> 往前走

3近 <> 远

4圣诞节的时候送苹果。[shèngdànjiéde shíhou sòng píngguǒ] : During Christmas, we give apples.
辛苦了~ 明天见

12/01/2016 Chinese Lesson

晚上好~

单词

1西红柿 xīhóngshì  : tomato

2音乐 yīnyuè : music

3玩 wán : play

4走 zǒu  : walk

5湖 hú : pond

句子



1太极拳是中国的传统武术。

2老师正在看报。

3唱歌 chang 2===》chang 4（o）

4吃西红柿身体好===》吃西红柿对身体好（o）

5周杰伦

辛苦了~ 明天见

11/30/2016

晚上好~

单词

1新闻 xīnwén : news

2方言 fāngyán  : dialect

句子

1现在电脑开着。

2我们在学汉语呢。

3玩玩===》玩一玩

4我用报纸看新闻。

5我用微信买火车票。

6从家到工作===》从家到公司（o）

7你看着，我来吧

辛苦了~ 明天见

11/29/2016

晚上好~

单词

1雨 yǔ  : rain

2发烧 fāshāo  :  have a fever

3太极拳 tàijíquán: t'ai chi ch'uan(traditional Chinese exercise)

4假 jiǎ  : lie

句子


1但是爸爸做菜做得不太好。

2他们说汉语说得怎么样？

3你们在中国过得好吗？

4下个周末下雪了===》上个周末下雪了（o）

5我工作在的时候头疼===》我在工作的时候头疼（o）

6门开着===》门关着

7真===》假

8我喜欢看音乐剧。


辛苦了~ 明天见

2016/11/28

晚上好~

单词

1做菜 zuòcài : cook

例句：你喜欢做菜吗？

2排骨 páigǔ : Galbi

例句：我可以做排骨。

3驾驶证 jiàshǐzhèng : driving license

4回来 [huílái] : return

5听得懂 [tīngdedǒng] : can understand

6味道 [wèidao] : taste

7唱 [chàng] : sing

8打篮球 [dǎlánqiú] : play a basketball

9开车 [kāichē] : drive a car

10踢足球[ tīzúqiú] : play a soccer

11跑步 [pǎobù] : run

12开始 [kāishǐ] : start

13舒服 [shūfu] : comfortable

14肚子 [dùzi] : stomache

15疼 [téng] / 痛 [tòng] : sick/ painful

16 开始 [kāishǐ] : start

17更 [gèng] : very much

18 厉害 [lìhai] : overwhelming/ spectacular

19 厉害 [lìhai]  : dumpling

20碗 [wǎn] : bowl

21简单 [jiǎndān] : simple

22危险 [wēixiǎn] : dangerous

23运动 [yùndòng] : exercise

24爬山 [páshān] : climb a mountain

25山顶 [shāndǐng] : mountain top

26下来 [xiàlái] : come down

27腿 [tuǐ] : leg

28游泳 [yóuyǒng] : swim

29练习 [liànxí] : practice


例句：在中国考驾驶证很难。

句子

1春  夏  秋  东[chūn xiá  qiū dōng] : spring, summer, fall, winter

2从家到公司很远，需要[xūyào] 2个小时 : from my house to work is very far away

3女司机[nǚsījī] : girl driver(implies negative and reckless driver..)

4需要一个时候===》需要一个小时（o）

5她汉字写得很漂亮。

辛苦了~ 明天见

2016/11/24 Chinese Lesson

晚上好~

单词


1冬天 dōngtiān : winter

2酸奶 suānnǎi : yoghurt

3写信 xiěxìn : write a letter

4包饺子 bāojiǎozǐ : make dumpling

5甜 tián : sweet

句子

1羽绒服非常很贵===》非常贵[fēicháng guì]（o）

2他打算下周末跟老师学汉语[tā dǎsuan xià zhuōmò gēn lǎoshī xué hànyu]

3以后想去美国生活吗[yǐhòu xiǎngqù měiguó shēnghuó ma]？

4我不知道他去哪了[wǒ bùzhīdao tā qù nǎr le]。

5我写信我的朋友了===》我给朋友写信了[wǒ gěi péngyou xiěxìn le]（o）

6从八点半开始工作。[cóng bādiǎnbàn kāishǐ gōngzuò]

辛苦了~ 明天见

2016/11/23 Chinese Lesson

单词

1造句 zàojù : make a sentence

2酒吧 jiǔbā : pub

3酒店 jiǔdiàn : hotel

4水果 shuǐguǒ : fruit

5理解 [lǐjiě] : understand

句子

 1这个周末你打算干什么？[zhège zhuōmò nǐ dǎsuan gān shénme] :
What are you planning to do this weekend?

2我能说汉语一点===》我能说一点汉语。（o）[wǒ néng shuō yīdiǎn hànyǔ]
: I can speak Chinese a little.


3我没有小时===》我没有时间（o）[wǒ méiyǒu shíjiān]
: I do not have time.

4你昨天买了几件衣服？[nǐ jīntiān máile jǐjiàn yīfu]
: How many clothes did you buy today?

5每天一个苹果，医生不找我。[měitiān yīge píngguǒ, yīshēng bù zhǎo wǒ].
One apple  a day, you don't need a doctor.

2016/11/22 Chinese Lesson

晚上好~

单词

1骑自行车 qízìxíngchē  : ride bicycle

2济州岛 jìzhōudǎo : Jeju Island

3百货商场 bǎihuòshāngchǎng : department store

4羽绒服 yǔróngfú : down jumper

5别说 [biéshuō] : certainly

6风景 [fēngjǐng] : view

7聯繫 [liánxì] : contact to

8网上购物 [wǎngshànggòuwù] : Internet shopping

9网点 [wǎngdiǎn] : e-commerce website

10光棍节 [guānggùnjié] : Singles' Day

11化妆品 [huàzhuāngpǐn]  : cosmetics


句子


1我喜欢骑自行车。


2你多长时间旅游济州岛？===》你什么时候去济州岛旅游的？（o）


3我没学过汉语。

4我的同屋是中国人了===》我的同屋是中国人。（o）

5不有脸书===》没有脸书[liǎnshū]  : do not have Facebook（o）

6我买东西上网===》我在网上买东西（o）

辛苦了~ 明天见

2016/11/21 Chinese Lesson

单词[dāncí] : word

1电视剧 diànshìjù : TV Drama

2男主角 nánzhǔjué : male main character

3动物园  dòngwùyuán  : zoo

4升旗 shēngqí : raise the flag

5景福宫 jǐngfúgōng : Kyoungbok Palace

6火车 huǒchē : train

7卧铺 wòpù : bed

8 壮观 [zhuàngguān] : spectacular view

9比较 [bǐjiào] : compare to 

10旅行 [lǚxíng] : travel

11语法 [yǔfǎ] : grammar

12页 [yè] : page

13坐 [zuò] : sit

14上铺 [shàngpù] : the upper bed of the bunk

15告诉 [gàosu] : let others know

16加 [jiā] : add 

句子[jùzi] : phrases

1全聚德 ：烤鸭店的名字

2我去过吃烤鸭===》我在北京吃过烤鸭（o）

3长城很厉害===》长城很壮观（o）

4 8 点===》8个小时[xiǎoshí]

2016/11/18 Chinese Lesson

您好~

今天的学习内容：

1.确实  què shí  : surely

2.出差 chū chāi  : business trip

3.机会 jī huì  : opportunity

4.女儿  nǚ ér  : daughter

5.橘子 jú zi : tangerine/mandarine

6.我北京在的时候（X）==》我在北京的时候（O）[wǒzài běijīng de shíhǒu]
: when I was in Beijing

7.我不公司职员（X）==》我不是公司职员（O）[wǒ búshì gōngsī zhíyuán]
: I'm not a worker.

8.你的女儿也有说一点吗？（X）==》你的女儿也会说话吗?（O）[nǐdě nǚ ér  yé huì shuōhuà ma]
: Can your daughter also speak?


9.济州岛的橘子很有名 jì zhōu dǎo de jú zǐ hěn yǒu míng  :
Mandarine from Jejudo is famous.


10.我去济州岛二次（X）==》我去过济州岛两次（O) [wǒ qùguo jìzhōudǎo liàngcí]


今天辛苦了~

 周末愉快~

2016/11/15 Chinese Lesson

您好~

今天的学习内容：

1.丸子  wán zǐ   : meatball

2.砖 zhuān : brick

3.高粱酒 gāo liáng jiǔ : Chinese alcohol

4.长城不漂亮cháng chéng bú piào liàng  : The Great Wall is not pretty.

5.长城 cháng chēng（X） ==》  cháng chéng（O）: The Great Wall

6.我一次喝过中国酒（X）==》我喝过一次中国酒（O）
: I've drunk Chinese alchohol once.

7.我也不可以韩国的白酒（X）==》我也不可以喝韩国的白酒（O）
: I've also drunk Korean alcohol.

8.你喝过中国酒没有？nǐ hě guò zhōng guó jiū  měi  yōu ？（X）==》nǐ hē guò zhōng guó jiǔ méi yǒu ？（O）
: Have you drunk Chinese alcohol?


今天辛苦了~ 明天见

2016/11/14 Chinese Lesson

您好~

今天的学习内容：

1.拍摄 pāi shè : filming

2.听说 tīng shuō   : from what I've heard

3.秘密 mì mì : secret

4.风 fēng  : wind
风大 ［fēngdà］： strong wind

5.羽绒服 yǔ róng fú : padding

6.羡慕 xiàn mù : envy

7.潮湿 cháo shī : moist

7.今天天气很好但是风很大 jīn tiān tiān qì hěn hǎo dàn shì fēng hěn dà
Today's weather's really good but the wind is strong.

8.听说明天下雪 tīng shuō míng tiān xià xuě
From what I've heard, it's gonna snow tomorrow.

9.妈妈做的菜特别好吃 mā ma zuò de cài tè bié hǎo chī
The food my moom cooked is really delicious.

10. 平时 [píngshí] : normal days

11. 蓝色 [lánsè] : blue

12. 运动服 [yùndòngfú] : training clothes

13. 而且 [érqiě] : furthermore

14. 形容词 [xíngróngcí] : adjective

15. 简单 [jiǎndān] : simple

今天辛苦了~

明天见

2016/11/11/ Chinese Lesson

您好~

今天的学习内容[nèiróng] :

1.网站  wǎng zhàn  : website

2.读dǔ （X）==》dú （O）: read

3.老公 lǎo gōng : husband

4.有多问题（X）==》有很多问题[yóu hěnduō wèntí]（O）:

5.同事   tóng shì   : coworker

6.堵车 dǔ chē  : (traffic)jammed

7.空气  kōng qì  : air

8.不有钱（X）==》没有钱[méiyǒu qián]（O）: do not have money

9.你的公司你的家很附近吗？（X）==》
你的公司和你的家很近吗[nǐde gōngsī hé nǐde jiā hěn yuǎn ma]（O）

10. 挎包 [kuàbāo] : shoulder bag

11. 老板 [lǎobǎn] : owner of the shop/ CEO

12. 厉害 [lìhai]: overwhelming/ respectful

13. 双 [shuāng] : two/pair

14. 看新闻 [kànxīnwén] : news/newspapers

15. 努力 [nǔlì] ： diligent

16. 大总统 [dàzǒngtǒng] :  president

17. 死 [sǐ] : die

18. 生气 [shēngqì] : angry

19. 地铁 [dìtiě] : subway

20. 出租车 [chūzūchē] : cab/taxi

21. 早饭 [zǎofàn]  : breakfast

22. 下午 [xiàwǔ] : afternoon

23. 午饭 [wǔfàn] : lunch

24. 晚饭 [wǎnfàn] : dinner

今天辛苦了~

周末愉快[zhōumò yúkuài] : Have a good weekend.

2016/11/10 Chinese Lesson

您好~

今天的学习内容：

1.加班费 jiā bān fèi   : overwork fee

2.房子 fáng zǐ  : house as in the objective building/housing

3.家  jiā  : house as in 'my house' that I'm living in.

4.实力  shí lì  : ability

5.朝鲜族 cháo xiān zú  : people of minority in China

6.听起来她的韩语韩国人（X）==》听起来她的韩语跟韩国人一样（O）
When I listen to his Korean, he speaks like Korean.

7.一点远（X）==》有点远（O）: A little bit far

8.老师都是中国人 lǎo shī dōu shì zhōng guó rén  : All the teachers are Chinese.

今天辛苦了

明天见。

2016/11/09 Chinese Lesson

您好~

今天的学习内容[nèiróng]：

1.上网 sháng wǎng (X)==>shàng wǎng （O）: Surfing the net

2.英国人 yīng guǒ rén  （X）==》yīng guó rén guǒ （O）:  English(person)

3.床 chuáng  : bed

4.桌子 zhuō zi  : desk

5.远 yuǎn  : far away

6.有点记得了(X）==》有点想起来了[yǒudiǎnr xiǎng qǐ lái le](O） : I remember a little bit.

7.我半年学习汉语（X）==》我学习了半年汉语[wǒ xuéxí le bànnián hànyǔ]（O) : I studied Chinese for half a year.

8.同屋  tóng wū  : roommate

9.为什么不喜欢德国吗？（X）==》
为什么不喜欢德国[wèishénme bù xǐhuan déguó]
: why don't you like Germany?

10. 翻译 [fānyì] : translate

11. 关系 [guānxi] : relationship

12.  共同 [gòngtóng] : common

13. 历史 [lìshǐ] : history

14. 日本人 [rìběnrén] : Japanese

15. 日本语 [Rìběnyǔ] : Japanese

16. 我想你 [wǒxiǎngnǐ] : i miss you.

今天辛苦[xīnkǔ]了~

明天见

2016/11/08 Chinese Lesson

您好~ 今天的学习内容：
 1.不错 bú cuò : pretty good : a pair of skirts
 3.一双鞋 yī shuāng xié : a pair of shoes
 4.瘦 shòu : thin
 5.就是 jiǔ shì（X） ==>jiù shì (O) : however
 6.菜cái(X)==》cài （O）: vegetables/ food
 7.我来过中国（X）==》我去过中国[wǒ qùguo zhōngguó]（O）: I've been to China.
 8.今天冷一点（X）==》今天有点冷[jīntiān yǒudiǎnr lěng]（O） : Today's a bit cold.
 9.想结婚他（X）==》想跟他结婚[xiáng gēn tā jiéhūn]（O）: I'd like to marry him.
 10.旁边 páng biǎn （X）==》 páng biān(O) : close to/ near
 今天辛苦了~ 明天见~

2016/11/07 Chinese Lesson

您好~
今天的学习内容( nèiróng)：
1.差不多  chà bù duō  비슷하다
2.不记得了bú jì dé le  기억이 안나다
3.左边儿 zuǒ biān ér  좌측
4.右边儿 yòu biān ér  우측
5.我也想买东西在淘宝（X）==》我也想在淘宝买东西（O）
6.太冷吗？(X)==》很冷吗？(O)
7.你去过韩国吗？（X)==》你来过韩国吗？（O）
5.我美国留学生(X)==>我是美国留学生（O）

今天辛苦了~
明天见~

2016/11/04 Chinese Lesson

单词：
1.咖啡厅：kā fēi tīng : cafe
       例句：我在咖啡厅。
             wǒ zài kā fēi tīng 。


2.拿铁：nátiě : latte
   例句：拿铁咖啡太苦了。
          ná tiě kā fēi tài kǔ le 。



3.下雪：xià xuě : snowing
    例句：中国已经下雪了。
            zhōng guó yǐ jīng xià xuě le 。



4.暖和：nuǎn huo : warm
  例句：最近有点儿暖和。
       zuì jìn yǒu diǎn er nuǎn hé 。

5.对面：duì miàn : in front of
  例句：我的朋友坐在我的对面。
       wǒ de péng yǒu zuò zài wǒ de duì miàn 。



句子：
1.我住在和我的父母==》我和我的父母住在一起。wǒ hé wǒ de fù mǔ zhù zài yī qǐ 。
I live with my parents together.



2.这个房子不错，但是附近的环境不好。
zhè gè fáng zǐ bú cuò ，dàn shì fù jìn de huán jìng bù hǎo 。
That room is not bad, but surrounding is not very good.


3.我今天喝了一点儿酒  wǒ jīn tiān hē le yī diǎn r jiǔ.
I drank a little today.

2016/11/03 Chinese Lesson

单词：
1.上网：shàng wǎng : Surfing on the net
  例句：我在上网。
       wǒ zài shàng wǎng 。



2.视频：shì pín : video
   例句：我在看视频。
        wǒ zài kàn shì pín 。



3.普洱茶：pǔ'ěrchá : Pu-erh tea    
例句：我好像喝过普洱茶。
         wǒ hǎo xiàng hē guò pǔ ěr chá 。



4.下雨：xià yǔ : raining
   例句：好像要下雨。
         hǎo xiàng yào xià yǔ 。


句子：
1.我不记得了。wǒ bú jì dé le 。
I do not remember.
2.我冬天不喝凉的啤酒。wǒ dōng tiān bù hē liáng de pí jiǔ 。
During cold weather, I do not drink cold beer.

3.但是多人喜欢喝凉的啤酒==》但是很多人都喜欢喝凉的啤酒dàn shì hěn duō rén dōu xǐ huān hē liáng de pí jiǔ
However, a lot of other people like to drink cold beer.

2016/11/02 Chinese Lesson

单词：
1.加班费：jiā bān fèi : overtime expense
       例句：我没有加班费。
            wǒ méi yǒu jiā bān fèi 。



2.经常：jīng cháng : always
  例句：我经常去电影院。
       wǒ jīng cháng qù diàn yǐng yuàn 。



3.约会：yuē huì : date/hanging out
   例句：约会的时候我们经常去电影院。
               yuē huì de shí hòu wǒ men jīng cháng qù diàn yǐng yuàn 。



4.个子矮：gè zi ǎi: height is short
    例句：我的男朋友个子矮。
        wǒ de nán péng yǒu gè zi ǎi 。


5.小说：xiǎo shuō : novel
  例句：这个电视剧以前是小说。
        wǒ de nán péng yǒu gè zǐ ǎi 。



6.辣的：là de : spicy
  例句：不要吃辣的菜。
         bú yào chī là de cài 。



7.炒年糕：chǎo nián gāo : ddoboki(Korean cuisine)
    例句：我也喜欢炒年糕
         wǒ yě xǐ huān chǎo nián gāo

8. 复习 [fùxí] : review

9. 男朋友 [nánpéngyou]  : boyfriend

10. 后年 [hòunián] : 2 years later

11. 善良的 [shànliángde] :kind

12. 不错 [búcuò] : fine

13. 没意思 [méiyìsi] : not fun

14. 药 [yào] : pill/medicine

15. 脸 [liǎn] : face

16. 敏感 [mǐngǎn] : sensitive

17. 朝鲜族 [Cháoxiǎnzú] : people of small minority living in China(조선족)

18. 汉族 [Hànzú] : Majority of people living in China

19. 有点儿 [yǒudiǎnr] : a little bit

20. 环境 [huánjìng]  : environment/ surrounding

句子：
1.你打算什么时候结婚？ nǐ dǎ suàn shén me shí hòu jié hūn ？
When are you planning to get married?
2.现在好点儿了。xiàn zài hǎo diǎn er le 。
Did you get better/ How do you feel now? ( From the disease/ sickness)

2016/11/01Basic Chinese

单词：
1.电影院：diàn yǐng yuàn : theatre
    例句：周末我去了电影院。
         zhōu mò wǒ qù le diàn yǐng yuàn 。

2.闻：wén : smell
例句：这个菜，闻起来很香。
       zhè gè cài ，wén qǐ lái hěn xiāng 。

3.澳门：ào mén : Macau
  例句:我去过香港和澳门。
     wǒ qù guò xiāng gǎng hé ào mén 。

4.芝士：zhīshì : Cheese
  例句：我喜欢吃芝士面包。
      wǒ xǐ huān chī zhī shì miàn bāo 。

5.法国：Fǎguó : France
  例句：他是法国人。

6.医院：yī yuàn: Hospital    医生：yīshēng : Doctor
 例句：我要去医院。
     wǒ yào qù yī yuàn 。

7. 感冒:gǎnmào: cold

8.  知道 : zhīdào : know

9. 觉得: juéde: regard as

10. 有名 : yǒumíng : famous

11. 有点儿 [yǒudiǎnr] : a little bit

12. 有意思 [yǒuyìsi] : interesting

13. 别的 [biéde] : different

14. 非常 [fēicháng] : very much

15. 新 [xīn] : new

16. 都 [dōu] : everyone/everything

17. 真的 [zhēnde] : really



句子：
1.你多大？nǐ duō dà ？
How old are you?
2.看起来，他是很帅==》看起来，他很帅
He looks handsome.
3.我脖子疼==》我嗓子疼。
wǒbózi  téng => wǒ sǎngzi téng
My neck hurts. => I have a sore throat.

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!

[MOVIE REVIEW] "500 Days of Summer"

The movie was out in 2009, so the movie's 6-year old now!
I've been wanting to watch the movie for a while now.
Today I had a half day off from work so I FINALLY watched the movie!

'500 Days of Summer' talks about a typical love between a man and a woman for 500 days.
Summer is an ordinary woman who just moved from Michigan to LA, and Summer meets Tom at work, another ordinary guy who happens to fall in love with Summer at first sight.

The movie shows a perspective of Tom throughout the movie. Maybe the the sequel in the perspective of Summer would be really interesting too! You've always gotta hear both sides of the story, right? I'm sure Summer would have things to say in her defense.

Tom seems like a good guy in the movie, while Summer's the bad one.
She suddenly tells Tom to break up with her without any understandable reasons.
Tom has hard time from the separation, believing that Summer is the one and only person for him.

The movie describes the 500 days of Tom being with Summer by going back and forth in time during the short relationship.
Summer doesn't want a "serious" relationship. They have casual sex and behave like a girlfriend and boyfriend to each other but Summer doesn't want to be called as "someone's something". So Tom keeps it that way. But he's confused, because he wants to be "Summer's boyfriend". However he never tells how he feels to Summer. He really should have done that - if he did, the ending of the story could have changed! While not telling Summer honestly about how he feels, he gets in fight with other guy who tries to buy Summer a drink at a pub and loses his temper to Summer sometimes.

I didn't hear what Summer had to say in the movie throughout the relationship, but if Tom was more upfront to Summer about his true feelings, things could have definitely changed. Tom never told Summer how much Summer meant to him, how eager he wanted to be Summer's special someone.

Summer never knew. She could only assume. If you only assume and think by yourself, your imagination can drive you to a whole different story-more likely a negative and inaccurate one. And so after all the imagination, Summer decides to end the relationship and finds another guy and gets married.

Tom finds a new girl at the job interview and Tom is gonna have another first day with another girl.

Two people nurtured from different environments for some 20 or 30 years are meant to have many differences. Maybe nobody is meant to be for each other. You have to constantly communicate to be a better fit for each other. In my opinion, 'communication' is the key. If you never tell and simply assume that another person will know, the other person will never know and you will lose the appropriate moment to talk about your true feelings. Your complaints toward another person would accumulate and you will become to think of ending the relationship. It's sometimes easier that way rather than enduring all the pain.

Every relationship's difficult, right?
'500 days of summer' is another love story that shows the natural phases of relationship.
The beginning of that rosy-colored glasses toward each other slowly turns into quarrels and fights.  All the relationships are gonna be the same if you do not learn or change how you communicate your true feelings in the relationship.

Let your special someone know how you truly feel! If they care, they will try to understand and make the necessary changes to be a better person for you. Then we will be able to see Summer and Tom living their happily ever after!

SQL Syntax - Part1

TABLE NAME : 'Customers' 

• SELECT
• Used ALMOST ALWAYS! Select the specific columns you want or '*' for every columns in a table

SELECT column_name1, column_name2

FROM table_name1;

or 

SELECT *

FROM table_name1;

-- everything!

• DISTINCT
• Select only the different(distinct values) among many duplicate

SELECT DISTINCT column_name, column_name
FROM table_name1;

• WHERE
• filter records; extract clause is used to extract only a specified criterion

SELECT column_name, column_name

FROM table_name1
WHERE column_name operator value;

ex) SELECT *
FROM Customers
WHERE Country='Mexico';

SELECT *
FROM Customers
WHERE ID=5;
-- you do not need single quotes('') in a number

Operators in the WHERE Clause

• = : equal
• <> / != : not equal
• > : greater than
• < : less than
• >= : greater than or equal
• <= : less than or equal
• BETWEEN: Between an inclusive range
• LIKE: Search for a pattern
• IN : multiple possible values including 'the value'

• AND
• Satisfies both the first AND second condition

SELECT * FROM Customers
WHERE Country = 'Germany' AND City = 'Berlin';

• OR
• Satisfies EITHER the first OR second condition

SELECT * FROM Customers
WHERE City = 'London' OR City = 'Berlin';

• Combining AND & OR

SELECT * FROM Customers
WHERE Country = 'Germany' AND (City = 'London' OR City = 'Berlin');

• Order By
• Sort the data by one or more columns
• could be ascending | descending

SELECT * FROM table_name
ORDER BY column_name ASC|DESC,  column_name ASC|DESC;

SELECT * FROM Customers
ORDER BY Country ASC, City DESC;

• INSERT INTO
• Insert new records in a table

INSERT INTO table_name
VALUES (value1, value2, value3, ...);

INSET INTO table_name(column1, column2, column3, ...)
VALUES(value1, value2, value3, ...);

INSERT INTO Customers(CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES('Sue', 'Park', 'TeheranRo', 'Seoul', '15320', South Korea)

Important SQL Commands

Here are some of the most widely used SQL commands
*they are not case-sensitive

• SELECT : extracts data from a database
• UPDATE: updates data in a database
• DELETE: deletes data from a database
• INSERT INTO: inserts new data into a database
• CREATE DATABASE: creates a new database
• ALTER DATABASE: modifies a database
• CREATE TABLE: creates a new table
• ALTER TABLE: modifies a table
• DROP TABLE: deletes a table
• CREATE INDEX: creates an index(search key)
• DROP INDEX: deletes an index 

Intro to SQL & Data Types in SQL

Let's learn SQL.

SQL stands for Structured Query Language.
It is used to communicate with a database. Query in SQL lets you organize and find the data you want in large database.

So what can you do with SQL?

• Execute queries against a DB
• Retrieve data from a DB
• Insert/update/delete records in a DB
• Create new DB
• Create new table in a DB
• Create stored procedures in DB
• Create views in a DB
• Set permissions on tables, procedures and views

We are first going to learn the main data types used in SQL.

There are a few different data types in SQL.
Data types could be divided into 3 main types :

1. Text and string types
text - a string of any length like Python str or unicode types
char(n) - a string of exactly n characters
archer(n) - a string of up to n characters

- String should always be put in 'single quotes' around text strings and date/time values
ex) '2012-11-23' : date/ text
without quotes 2012-11-23 : this is an integer expression

2. Numeric types
integer - an integer value, like Python int
real - a floating-point value, like Python float. Accurate up to six decimal places.
double precision - a higher-precision floating-point value. Accurate up to 15 decimal places.
decimal - an exact decimal value

3. Date and time types
date - a calendar date; including year, month, and day.
time - a time of day
timestamp - a date and time together

[Bloomberg Article] Wal-Mart to Acquire Jet.com for $3.3 Billion to Fight Amazon

Wal-Mart has recently took over Jet.com to gain more dominance in the e-commerce market.

I am going to write down a list of sentences from the article and highlight the important words and explain their meanings for everyone to share and use it in their daily lives.

1.  The move is Wal-Mart’s biggest attempt to date to chase down Amazon, which has dominated e-commerce in much the same way that Wal-Mart has ruled brick-and-mortar retail.

- brick-and-mortar : it describes the physical presence of a building or other structure.

ex) For sure, Wal-Mart is a dominant player in the brick-and-mortar retail!

2. It also started a subscription service similar to Amazon Prime, at half the price, but still trails the e-commerce behemoth in online sales.

- behemoth : a huge or monstrous creature

ex) Amazon is the e-commerce behemoth in the USA.

3. Traditional store-based mass retailers such as Wal-Mart, Target Corp. and Costco Wholesale Corp. have been struggling to fend off Amazon’s momentum in online shopping.

- fend off : prevent the occurrence of; prevent from happening

ex) South Korea fends off any potential attacks from North Korea by initiating THAAD system.

4. Wal-Mart is betting that if anyone can help it catch up to Amazon, it’s Jet.com founder Lore, 45, duked it out with Amazon as founder and chief executive officer of Quidsi, best known for Diapers.com, before a protracted price war and tight credit market during the Great Recession forced him to sell to his competitor for $550 million in 2010.

- duke something out : to fight, usually fist fight.

ex) Amazon ducked Ebay out with dramatic increase of market share via Prime Membership.

- protracted : relatively long in duration

ex) The negotiation has been protracted for months now. It's gotta end sooner or later.

source :

http://www.bloomberg.com/news/articles/2016-08-08/wal-mart-agrees-to-buy-jet-com-for-3-billion-to-fight-amazon

Building an Android App

Building Layout Part 1

UI (User Interface) : the whole layout of the app

1. VIEWS

- rectangle on an app

ex) picture, button...etc.

- it always has to be in camel case, meaning no spaces and the  first letter always capitalized

Parts consisting views are;

1. TextView : text

2. ImageView : pictures

3. Button

2. IDE(Integrated Design Environment) - Android Studio in our case!

- XML(eXtensible Markup Language) : 

way to describe how your android app's gonna look 

- XML Syntax:

syntax means rules that make valid/invalid xml

example of XML; 

<TextView
android:text = "Hello world"
android:layout_width="wrap_content"
android:layout_height="wrap_content" />

*wrap_content: adjusts the width of the text view to perfectly fit the contents inside it!

- Attributes:
width/height/background/text
-> describes how the 'textview' is gonna look
-> should be put in quotation("")

- <TextView> has default values
-> if you are okay with default values, you don't have to set attributes
-> you have to use precise names/symbols or not there will be errors!
     ex)TextView CANNOT BE TxtView, Textview, text view... etc.

3. Density-independent pixels(DP)

medium resolution device < high resolution device < extra-high resolution device
same physical device for 2 dp by 2dp but different no. of pixels are used in different resolution device!
*dp: density independent pixels

*TIP:
Make touch targets 48dp at least! Otherwise it's gonna be really small.

4. Typography/ Color

- SP(screen pixels) to declare font size
ex) android:textSie = "45sp"

* Useful URL to typography:
https://material.google.com/style/typography.html#
* color: https://material.google.com/style/color.html#

- XML: How to change the color of the background & the content
<TextView
    android:text="wait wait today is your birthday?"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:textColor="#B71C1C"
    android:background="#FFCDD2"
    android:textSize="45sp"
/>

ImageView
<ImageView
    android:src="@drawable/rocks"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:scaleType="centerCrop"
/>

android:scaleType="centerCrop"
-> gets the image to fully fill the screen
-> good tool to make the immersive looking screen

URL to Android Developers:
https://developer.android.com/index.html

My first post!

Hello,

I have just started to learn some programming.
My major is Psychology am I am now working as a product manager(PM).

I always thought it'd be a good idea to learn some programming skill whenever I have the time to do it.

While learning programming, I thought I'd share what I'm learning on the blog for everyone who's interested in programming.

I hope that one day I will be able to make my own program/app from the scratch and benefit others with my program/app!