Difference between pages "The JOIN operation" and "User:Rr8y1q7s84"

From SQLZOO
(Difference between pages)
Jump to: navigation, search
m (Q2: "for game 1012" in question, "WHERE id=1023")
 
(mother is only one opinion: new section)
 
Line 1: Line 1:
<div class="ref_section">
+
== "That cold when she had saved up ==
<table class='db_ref'>
+
<caption>game</caption>
+
<tr>
+
<th>id</th>
+
<th>mdate</th>
+
<th>stadium</th>
+
<th>team1</th>
+
<th>team2</th>
+
</tr>
+
<tr>
+
<td>1001</td>
+
<td>8 June 2012</td>
+
<td>National Stadium, Warsaw</td>
+
<td>POL</td>
+
<td>GRE</td>
+
</tr>
+
<tr>
+
<td>1002</td>
+
<td>8 June 2012</td>
+
<td>Stadion Miejski (Wroclaw)</td>
+
<td>RUS</td>
+
<td>CZE</td>
+
</tr>
+
<tr>
+
<td>1003</td>
+
<td>12 June 2012</td>
+
<td>Stadion Miejski (Wroclaw)</td>
+
<td>GRE</td>
+
<td>CZE</td>
+
</tr>
+
<tr>
+
<td>1004</td>
+
<td>12 June 2012</td>
+
<td>National Stadium, Warsaw</td>
+
<td>POL</td>
+
<td>RUS</td>
+
</tr>
+
<tr>
+
<td colspan='5'>...</td>
+
</tr>
+
</table>
+
<br/>
+
<table class='db_ref'>
+
<caption>goal</caption>
+
<tr>
+
<th>matchid</th>
+
<th>teamid</th>
+
<th>player</th>
+
<th>gtime</th>
+
</tr>
+
<tr>
+
<td>1001</td>
+
<td>POL</td>
+
<td>Robert Lewandowski</td>
+
<td>17</td>
+
</tr>
+
<tr>
+
<td>1001</td>
+
<td>GRE</td>
+
<td>Dimitris Salpingidis</td>
+
<td>51</td>
+
</tr>
+
<tr>
+
<td>1002</td>
+
<td>RUS</td>
+
<td>Alan Dzagoev</td>
+
<td>15</td>
+
</tr>
+
<tr>
+
<td>1001</td>
+
<td>RUS</td>
+
<td>Roman Pavlyuchenko</td>
+
<td>82</td>
+
</tr>
+
<tr>
+
<td colspan='5'>...</td>
+
</tr>
+
</table>
+
<br/>
+
<table class='db_ref'>
+
<caption>eteam</caption>
+
<tr>
+
<th>id</th>
+
<th>teamname</th>
+
<th>coach</th>
+
</tr>
+
<tr>
+
<td>POL</td>
+
<td>Poland</td>
+
<td>Franciszek Smuda</td>
+
</tr>
+
<tr>
+
<td>RUS</td>
+
<td>Russia</td>
+
<td>Dick Advocaat</td>
+
</tr>
+
<tr>
+
<td>CZE</td>
+
<td>Czech Republic</td>
+
<td>Michal Bilek</td>
+
</tr>
+
<tr>
+
<td>GRE</td>
+
<td>Greece</td>
+
<td>Fernando Santos</td>
+
</tr>
+
<tr>
+
<td colspan='5'>...</td>
+
</tr>
+
</table>
+
</div>
+
  
 +
'clock that morning, she went to the Yongchuan city the Chuandong farmers market wholesale a load of water chestnuts, pick a river to wash the mud outside the market. Fruit facade away from the river about 100 meters there, the boss called Wei Zhaojun. He to hear Sister Tam drowning cry for help, and immediately jumped into the river. Three or four minutes later,air jordan, Tan Sister was put ashore, foaming at the mouth, shivering. Yesterday,jordan, Wei Zhaojun pulled out a piece of paper, and said that three consecutive sleepless nights after the rescue, he wrote the diary. My discontent: 120 twelfth lunar month,バーバリー, the ninth day, I heard that some people fell in the water near the river,burberry, quickly ran to the river, took off his coat to save the drowning person from the middle of the river on the shore. Before me into the water, there are a lot of people hit 120. I drowning rescue to shore, the water is still Tubai Mo. Can 120 is yet to come, if 120 come, drowning person not died. I feel particularly sad. He told reporters: "That cold when she had saved up, I almost cold fainted she is still alive, however, one or two hundred people and other yo hope you 120 ambulances to the scene did not open last a large living abruptly froze to death. "semi the hours Panlai many business operators are eyewitness ambulance market. Talking about happened Sister Tam rescued,mulberry outlet, we are very angry. Witnesses said Xie Ping, Tan Sister rescued after the water vapor permeability of the underwear,モンクレール, it is difficult to take off quickly, she immediately got a batt Tan systemic wrapped. At that time, Tan Sister not dead. Wei Zhaojun's brother was one of the people dial 120. He said he made it clear to the operator the trouble hair specific location,air jordan, please ambulance as soon as possible to save lives. The other told him quickly to health care workers. Call 120 about 20 minutes after the district police station police car approaching. "Such as police, irritated to the 120 call, said" not to have to bear the responsibility. "Witnesses Mr. Zhao said. The Yongchuan District Police confirmed the emergency police car to go to the hospital,burberry, near the market encountered ambulance sent to Tan Sister, health care personnel on-site diagnosis Tan had died. the reporter interviewed eyewitnesses message: Tan rescued until police car encountered the ambulance about 30 minutes. ambulances on the road in case of "traffic jam" from the the Chuandong farmers' wholesale market is about 1 km, the Yongchuan District Hospital; 2 km local Second City Hospital. lot of presence does not want to understand: the distance is not far, why the half-hour did not see an ambulance  yesterday afternoon, the reporter from a city hospital Chongqing Emergency Center Yongchuan sub-centers was informed that the locals Chongqing membership phone number or local landline call 120 sub-centers will be receiving help. the city hospital Yuanban message said,burberry pas cher, the sub-centers receiving help, usually notify the hospital ambulance to Tan Sister life flashes every second, sub-centers why not make an exception assigned from the scene near the Chinese medicine hospital sent a car to go to  the city hospital Xuanjiao Ke's explanation is not affiliated hospital with the Traditional Chinese Medicine Hospital relationship may be declined almost time even if the convergence with the Chinese medicine hospital immediately sent to the scene to rescue the other ambulance "to spend more than 10 minutes" to exit, and follow the city hospital ambulances City Second Hospital of Medical Services news : The same day, the hospital ambulance discharged time is 9:49, when he ran into a traffic jam. later encountered on the way the police car sent to Tan Sister death The investigation Tan. Finally, an ambulance back to the hospital. the Medical Services frankly,louboutin pas cher, The ambulance took 34 minutes out of the bus to return to hospital.</p><p>
 +
Related articles:
 +
<ul>
 +
 
 +
  <li>deprived of political rights for three years and fined 50</li>
 +
 
 +
  <li>as well as the three sisters. Lian Yong from childhood as the only boy in the family</li>
 +
 
 +
  <li>where traffic is heavy</li>
 +
 
 +
</ul>
  
  <h2>JOIN and UEFA EURO 2012</h2>
+
== in addition to the 8-note hi in the second prize of 48 ==
  <p>This tutorial introduces JOIN which allows you to use data from two or more tables. The tables contain all matches and goals from UEFA EURO 2012 Football Championship in Poland and Ukraine.</p>
+
  
<div class="progress_panel"><div>
+
's house New Year,air jordan, nothing better to do, he purchased the current Lottery newspaper. Analysis,モンクレール, Zhang accumulated nearly a million in prize money due to the previous period period a winning opportunity,louboutin pas cher, therefore, he has increased the amount of bets,burberry, spent 200 yuan to buy a total of 100 Note 20 football lottery. Unexpectedly,air jordan, 100 Note in the lottery, not only to embrace a Note 496 million First into the pocket,burberry soldes, in addition to the 8-note hi in the second prize of 48,jordan,766 yuan bonus for each note,burberry pas cher, winning 5.35 million yuan in total. "Can finally get rid of the fate of the workers." Zhang said excitedly,air ジョーダン, he wants to use more than 500 million in home business,jordan, help more unemployed brothers and sisters like him employment. The reporter Zhang securinine intern Li Shu</p><p>
  <div class="summary">Summary</div>
+
Related articles:
  <div class="progressbarbg">
+
<ul>
    <div class="progressbar"></div>
+
 
  </div>
+
  <li>no unpleasant odor</li>
</div></div>
+
 
+
  <div class='extra_space' style='width:1em; height:6em;'></div>
+
 
    
 
    
<div class='qu'>
+
  <li>00 However</li>
The first example shows the goal scored by 'Bender'.
+
 
 +
  <li>"November 5</li>
 +
 
 +
</ul>
  
<p class='imper'>Show '''matchid''' and '''player''' name for all goals scored by Germany.
+
== mother is only one opinion ==
<code>teamid = 'GER'</code></p>
+
  
<source lang='sql' class='def'>
+
's heart can not stand changed to "3000000". Mom urged to accept the award, and quickly be secured later, he finally put their own in the message of 70,060,000, and told my mom,burberry, mother is only one opinion: as soon as possible to receive the award, can be secured. So, yesterday, Xiao Ming arrived in Hangzhou. In front of reporters, the young man finally tell the many stories of their own to buy lottery tickets. He said that this lucky lottery "is indeed machine selection to that newsstand the proprietress Yao Shudan random break out to him, he confirmed, then purchased additional 8 times, a total cost of 24 yuan . Xiao Ming lottery numbers never "studies" always random buy, but he's Gambling history can be traced back to 11 years ago. When Xiao Ming is just a Hangzhou University students in school, he began to buy Lottery "6 +1" Over the years,air jordan, the times he bet cast also became a "weapon". Once Once, Xiao Ming Wen San Road,air jordan, Hangzhou,louboutin pas cher, a Lottery-point 4-fold buy "6 +1" cast, the outlets was really in a 4-fold Award, and he was once mistaken own. Do not buy a car, that they consider building hope primary school lucky in the end is what kind of person  Yesterday he revealed that he is the SOHO, currently being entrepreneurial in. He has a small white-collar workers, a few years ago in Hangzhou,burberry pas cher, Shanghai's real estate sector, the media sector have worked. Speaking of the answer given by the sum large sums of money in the end will be used where respect for individuality, maverick Xiao Ming is very surprising. Seen through the Chinese property market, "he will not immediately buy a house, temporarily would not consider buying a car, but will not consider the purchase of more than 500,000 luxury car. The young man also revealed that he is "not marriages, and therefore will not immediately spend a lot of money to get married. Get the hands of more than 5600 million, will be the most valuable of the pot of gold in his life,ジョーダン, "Little said bring it as a cornerstone of life,jordan, investment, making the money" background in economics,バーバリー, he really understands how to make "chicken-and-egg and then hatching chickens ......" "But go back,burberry soldes, would consider was built in the name of the mother of an elementary school,mulberry outlet," he said earnestly.</p><p>
SELECT * FROM goal
+
Related articles:
  WHERE player LIKE '%Bender'
+
<ul>
</source>
+
 
 
+
  <li>resulting in the left cheek cheekbone hematoma</li>
<source lang='sql' class='ans'>
+
 
SELECT matchid, player
+
  <li>Chamberlain found a red blot. Brush the surface surface dust</li>
FROM goal
+
    
  WHERE teamid LIKE 'GER'
+
  <li>it broke basketball is no more interested in</li>
</source>
+
 
</div>
+
</ul>
 
+
<div class='qu'>
+
From the previous query you can see that Lars Bender's goal was scored in game 1012.
+
Notice that the column '''matchid''' in the '''goal''' table corresponds to the '''id''' column in the '''game''' table.
+
<p class='imper'>Show id, stadium, team1, team2 for game 1012</p>
+
 
+
<source lang='sql' class='def'>
+
SELECT id,stadium,team1,team2
+
  FROM game
+
WHERE stadium LIKE '%Warsaw%'
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT id,stadium,team1,team2
+
FROM game
+
WHERE id=1012</source>
+
</div>
+
 
+
<div class='qu'>
+
You can combine the two steps into a single query with a join. You will get all the '''game''' details and all the '''goal''' details if you use
+
SELECT *
+
  FROM game JOIN goal ON (id=matchid)
+
<p class='imper'>Show the player, teamid and mdate and for every German goal. <code>teamid='GER'</code></p>
+
 
+
<source lang='sql' class='def'>
+
SELECT player,stadium
+
  FROM game JOIN goal ON (id=matchid)
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT player,teamid,mdate
+
  FROM game JOIN goal ON (id=matchid)
+
WHERE teamid='GER'
+
</source>
+
</div>
+
 
+
<div class='qu'>
+
Use the same join as in the previous question.
+
<p class='imper'>Show the team1, team2 and player for every goal scored by a player called Mario <code>player LIKE 'Mario%'</code></p>
+
 
+
<source lang='sql' class='def'>
+
 
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT team1, team2, player
+
  FROM game JOIN goal ON (id=matchid)
+
WHERE player LIKE 'Mario%'</source>
+
</div>
+
 
+
<div class='qu'>
+
The table '''eteam''' gives details of every national team including the coach. You can JOIN '''goal''' to '''eteam''' using the phrase <code>goal JOIN eteam on teamid=id</code>
+
<p class='imper'>Show player, teamid, coach, gtime for all goals scored in the first 10 minutes <code>gtime&lt;=10</code></p>
+
 
+
<source lang='sql' class='def'>
+
SELECT player, teamid, gtime
+
  FROM goal
+
WHERE gtime<=10
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT player, teamid, coach, gtime
+
  FROM goal JOIN eteam ON (teamid=id)
+
WHERE gtime<=10
+
</source>
+
</div>
+
 
+
<div class='qu'>
+
To JOIN '''game''' with '''eteam''' you could use either<br/> <code>game JOIN eteam ON (team1=eteam.id)</code> or <code>game JOIN eteam ON (team2=eteam.id)</code>
+
 
+
Notice that because '''id''' is a column name in both '''game''' and '''eteam''' you must specify '''eteam.id''' instead of just '''id'''
+
<p class='imper'>List the dates of the matches in which 'Fernando Santos' was the team1 coach.</p>
+
 
+
<source lang='sql' class='def'>
+
 
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT mdate,teamname
+
  FROM game JOIN eteam ON (team1=eteam.id)
+
WHERE coach='Fernando Santos'
+
</source>
+
</div>
+
 
+
<div class='qu'>
+
<p class='imper'>List the player for every goal scored in a game where the staium was 'National Stadium, Warsaw'</p>
+
 
+
<source lang='sql' class='def'>
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT player
+
  FROM goal JOIN game ON (id=matchid)
+
WHERE stadium = 'National Stadium, Warsaw'
+
</source>
+
</div>
+
 
+
 
+
 
+
<br/><br/><br/><br/>
+
<h2>More difficult questions</h2>
+
<div class='qu'>
+
<div>This query shows all goals scored in Germany-Greece quarterfinal.</div>
+
 
+
<p class='imper'>Show names of all players who scored a goal against Germany.</p>
+
<div class="hint" title="HINT">
+
Select goals scored by non-German players in matches where GER was the id of either '''team1''' or '''team2'''.
+
 
+
You can use <code>teamid!='GER'</code> to prevent listing German players.
+
 
+
You can use DISTINCT to stop players being listed twice.
+
</div>
+
 
+
<source lang='sql' class='def'>
+
SELECT player, gtime
+
  FROM game JOIN goal ON matchid = id
+
    WHERE (team1='GER' AND team2='GRE')
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT DISTINCT player
+
  FROM game JOIN goal ON matchid = id
+
WHERE (team1 = 'GER' OR team2 = 'GER')
+
  AND teamid!='GER'
+
</source>
+
</div>
+
 
+
<div class='qu'>
+
 
+
<div class='imper'>Show '''teamname''' and the total number of goals scored.</div>
+
<div class="hint" title="COUNT and GROUP BY">
+
You should COUNT(*) in the SELECT line and GROUP BY teamname
+
</div>
+
<source lang='sql' class='def'>
+
SELECT teamname, player
+
  FROM eteam JOIN goal ON id=teamid
+
ORDER BY teamname
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT teamname,COUNT(teamid)
+
  FROM eteam JOIN goal ON id=teamid
+
GROUP BY teamname
+
</source>
+
</div>
+
 
+
 
+
<div class='qu'>
+
<div class='imper'>Show the stadium and the number of goals scored in each stadium.
+
</div>
+
<source lang='sql' class='def'>
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT stadium,COUNT(1)
+
  FROM goal JOIN game ON id=matchid
+
GROUP BY stadium</source>
+
</div>
+
 
+
<div class='qu'>
+
<div class='imper'>For every match involving 'POL', show the matchid date and the number of goals scored.</div>
+
<source lang='sql' class='def'>
+
SELECT matchid,mdate, team1, team2,teamid
+
  FROM game JOIN goal ON matchid = id
+
WHERE (team1 = 'POL' OR team2 = 'POL')
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT matchid,mdate,COUNT(teamid)
+
  FROM game JOIN goal ON matchid = id
+
WHERE (team1 = 'POL' OR team2 = 'POL')
+
GROUP BY matchid,mdate
+
</source>
+
</div>
+
 
+
<div class='qu'>
+
 
+
<div class='imper'>For every match where 'GER' scored, show the number of goals scored by 'GER'</div>
+
<source lang='sql' class='def'>
+
</source>
+
<source lang='sql' class='ans'>
+
SELECT matchid,mdate,COUNT(teamid)
+
  FROM game JOIN goal ON matchid = id
+
WHERE (teamid='GER')
+
GROUP BY matchid,mdate
+
</source>
+
</div>
+
<div>
+
 
+
<div class='qu'>
+
 
+
<div class='imper'>List every match with the goals scored by each team as shown.</div>
+
<table class="sqlmine">
+
<tr><th>mdate</th><th>team1</th><th>score1</th><th>team2</th><th>score2</th></tr>
+
<tr><td>1 July 2012</td><td>ESP</td><td class="r">4</td><td>ITA </td><td class="r">0</td></tr>
+
<tr><td>10 June 2012</td><td>ESP</td><td class="r">1</td><td>ITA</td><td class="r">1</td></tr>
+
<tr><td>10 June 2012</td><td>IRL</td><td class="r">1</td><td>CRO</td><td class="r">3</td></tr>
+
<tr><td colspan=5>...</td></tr>
+
</table>
+
Notice in the query given every goal is listed. If it was a team1 goal then a 1 appears in score1, otherwise there is a 0. You could SUM this column to get a count of the goals scored by team1.
+
<source lang='sql' class='def'>
+
SELECT mdate,
+
  team1,
+
  CASE WHEN teamid=team1 THEN 1 ELSE 0 END score1
+
  FROM game JOIN goal ON matchid = id
+
</source>
+
 
+
<source lang='sql' class='ans'>
+
SELECT mdate,
+
   team1,
+
  SUM(CASE WHEN teamid=team1 THEN 1 ELSE 0 END) score1,
+
  team2,
+
  SUM(CASE WHEN teamid=team2 THEN 1 ELSE 0 END) score2
+
  FROM game JOIN goal ON matchid = id
+
GROUP BY mdate,matchid,team1,team2
+
</source>
+
 
+
</div>
+
<div>
+
<div class="lsclear">Clear your results</div>
+
 
+
<p><div class="quizlink">[[JOIN Quiz]]</div></p>
+
</div>
+
[[Old JOIN Tutorial]]
+
<p>[http://sqlzoo.net/w/index.php/More_JOIN_operations The next tutorial about the Movie database involves some slightly more complicated joins.]</p>
+

Revision as of 23:20, 10 October 2012

"That cold when she had saved up

'clock that morning, she went to the Yongchuan city the Chuandong farmers market wholesale a load of water chestnuts, pick a river to wash the mud outside the market. Fruit facade away from the river about 100 meters there, the boss called Wei Zhaojun. He to hear Sister Tam drowning cry for help, and immediately jumped into the river. Three or four minutes later,air jordan, Tan Sister was put ashore, foaming at the mouth, shivering. Yesterday,jordan, Wei Zhaojun pulled out a piece of paper, and said that three consecutive sleepless nights after the rescue, he wrote the diary. My discontent: 120 twelfth lunar month,バーバリー, the ninth day, I heard that some people fell in the water near the river,burberry, quickly ran to the river, took off his coat to save the drowning person from the middle of the river on the shore. Before me into the water, there are a lot of people hit 120. I drowning rescue to shore, the water is still Tubai Mo. Can 120 is yet to come, if 120 come, drowning person not died. I feel particularly sad. He told reporters: "That cold when she had saved up, I almost cold fainted she is still alive, however, one or two hundred people and other yo hope you 120 ambulances to the scene did not open last a large living abruptly froze to death. "semi the hours Panlai many business operators are eyewitness ambulance market. Talking about happened Sister Tam rescued,mulberry outlet, we are very angry. Witnesses said Xie Ping, Tan Sister rescued after the water vapor permeability of the underwear,モンクレール, it is difficult to take off quickly, she immediately got a batt Tan systemic wrapped. At that time, Tan Sister not dead. Wei Zhaojun's brother was one of the people dial 120. He said he made it clear to the operator the trouble hair specific location,air jordan, please ambulance as soon as possible to save lives. The other told him quickly to health care workers. Call 120 about 20 minutes after the district police station police car approaching. "Such as police, irritated to the 120 call, said" not to have to bear the responsibility. "Witnesses Mr. Zhao said. The Yongchuan District Police confirmed the emergency police car to go to the hospital,burberry, near the market encountered ambulance sent to Tan Sister, health care personnel on-site diagnosis Tan had died. the reporter interviewed eyewitnesses message: Tan rescued until police car encountered the ambulance about 30 minutes. ambulances on the road in case of "traffic jam" from the the Chuandong farmers' wholesale market is about 1 km, the Yongchuan District Hospital; 2 km local Second City Hospital. lot of presence does not want to understand: the distance is not far, why the half-hour did not see an ambulance yesterday afternoon, the reporter from a city hospital Chongqing Emergency Center Yongchuan sub-centers was informed that the locals Chongqing membership phone number or local landline call 120 sub-centers will be receiving help. the city hospital Yuanban message said,burberry pas cher, the sub-centers receiving help, usually notify the hospital ambulance to Tan Sister life flashes every second, sub-centers why not make an exception assigned from the scene near the Chinese medicine hospital sent a car to go to the city hospital Xuanjiao Ke's explanation is not affiliated hospital with the Traditional Chinese Medicine Hospital relationship may be declined almost time even if the convergence with the Chinese medicine hospital immediately sent to the scene to rescue the other ambulance "to spend more than 10 minutes" to exit, and follow the city hospital ambulances City Second Hospital of Medical Services news : The same day, the hospital ambulance discharged time is 9:49, when he ran into a traffic jam. later encountered on the way the police car sent to Tan Sister death The investigation Tan. Finally, an ambulance back to the hospital. the Medical Services frankly,louboutin pas cher, The ambulance took 34 minutes out of the bus to return to hospital.</p>

Related articles:

  • deprived of political rights for three years and fined 50
  • as well as the three sisters. Lian Yong from childhood as the only boy in the family
  • where traffic is heavy

in addition to the 8-note hi in the second prize of 48

's house New Year,air jordan, nothing better to do, he purchased the current Lottery newspaper. Analysis,モンクレール, Zhang accumulated nearly a million in prize money due to the previous period period a winning opportunity,louboutin pas cher, therefore, he has increased the amount of bets,burberry, spent 200 yuan to buy a total of 100 Note 20 football lottery. Unexpectedly,air jordan, 100 Note in the lottery, not only to embrace a Note 496 million First into the pocket,burberry soldes, in addition to the 8-note hi in the second prize of 48,jordan,766 yuan bonus for each note,burberry pas cher, winning 5.35 million yuan in total. "Can finally get rid of the fate of the workers." Zhang said excitedly,air ジョーダン, he wants to use more than 500 million in home business,jordan, help more unemployed brothers and sisters like him employment. The reporter Zhang securinine intern Li Shu

Related articles:

  • no unpleasant odor
  • 00 However
  • "November 5

mother is only one opinion

's heart can not stand changed to "3000000". Mom urged to accept the award, and quickly be secured later, he finally put their own in the message of 70,060,000, and told my mom,burberry, mother is only one opinion: as soon as possible to receive the award, can be secured. So, yesterday, Xiao Ming arrived in Hangzhou. In front of reporters, the young man finally tell the many stories of their own to buy lottery tickets. He said that this lucky lottery "is indeed machine selection to that newsstand the proprietress Yao Shudan random break out to him, he confirmed, then purchased additional 8 times, a total cost of 24 yuan . Xiao Ming lottery numbers never "studies" always random buy, but he's Gambling history can be traced back to 11 years ago. When Xiao Ming is just a Hangzhou University students in school, he began to buy Lottery "6 +1" Over the years,air jordan, the times he bet cast also became a "weapon". Once Once, Xiao Ming Wen San Road,air jordan, Hangzhou,louboutin pas cher, a Lottery-point 4-fold buy "6 +1" cast, the outlets was really in a 4-fold Award, and he was once mistaken own. Do not buy a car, that they consider building hope primary school lucky in the end is what kind of person Yesterday he revealed that he is the SOHO, currently being entrepreneurial in. He has a small white-collar workers, a few years ago in Hangzhou,burberry pas cher, Shanghai's real estate sector, the media sector have worked. Speaking of the answer given by the sum large sums of money in the end will be used where respect for individuality, maverick Xiao Ming is very surprising. Seen through the Chinese property market, "he will not immediately buy a house, temporarily would not consider buying a car, but will not consider the purchase of more than 500,000 luxury car. The young man also revealed that he is "not marriages, and therefore will not immediately spend a lot of money to get married. Get the hands of more than 5600 million, will be the most valuable of the pot of gold in his life,ジョーダン, "Little said bring it as a cornerstone of life,jordan, investment, making the money" background in economics,バーバリー, he really understands how to make "chicken-and-egg and then hatching chickens ......" "But go back,burberry soldes, would consider was built in the name of the mother of an elementary school,mulberry outlet," he said earnestly.

Related articles:

  • resulting in the left cheek cheekbone hematoma
  • Chamberlain found a red blot. Brush the surface surface dust
  • it broke basketball is no more interested in

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense