你们都去吗［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
2016년 10월 15일 토요일
[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!
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
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
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
2016년 10월 3일 월요일
[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
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
2016년 10월 2일 일요일
[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!
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!
2016년 9월 13일 화요일
[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!
피드 구독하기:
글 (Atom)