- 博客(4)
- 收藏
- 关注
原创 sqlzoo练习答案4
六.Using Null5.Use COALESCE to print the mobile number. Use the number '07986 444 2266' if there is no number given. Show teacher name and mobile number or '07986 444 2266'select name,coalesce(mobile,'...
2018-06-26 18:25:12 376
原创 sqlzoo练习答案3
四.The JOIN13.List every match with the goals scored by each team as shown. This will use "CASE WHEN" which has not been explained in any previous exercises.mdateteam1score1team2score21 July 2012ESP4IT...
2018-06-25 17:41:52 708
原创 sqlzoo练习答案2
三.SELECT within SELECT3.List the name and continent of countries in the continents containing either Argentina or Australia. Order by name of the country.select name,continent from worldwhere continen...
2018-06-25 13:15:27 416
原创 sqlzoo练习答案1
一.SELECT from WORLD8.Exclusive OR (XOR). Show the countries that are big by area or big by population but not both. Show name, population and area.SELECT name,population,area FROM worldWHERE area>3...
2018-06-25 11:20:33 1830
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人