HackerRank第一趴--Basic Select

徐若离 2023-03-28 原文

CITY表：

Field	Type
ID	number
NAME	VARCHAR2（17）
COUNTRYCODE	VARCHAR2（3）
DISTRICT	VARCHAR2（20）
POPULATION	number

1.Revising the Select Query I

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

select * from CITY
where POPULATION>=100000 and COUNTRYCODE='USA';

2.Revising the Select Query II

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

select Name from CITY
where COUNTRYCODE ='USA' and POPULATION>=120000;

3.Select All

Query all columns (attributes) for every row in the CITY table.

select * from CITY;

4.Select By ID

Query all columns for a city in CITY with the ID 1661.

select * from CITY
where ID =1661;

5.Japanese Cities' Attribute

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

select * from CITY
where COUNTRYCODE='JPN';

6.Japanese Cities' Name

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

select NAME
from CITY
where COUNTRYCODE='JPN'

7. Query a count of the number of cities in CITY having a Population larger than 10,000.

select count(NAME) 
from CITY
where POPULATION>100000;

8.Query the total population of all cities in CITY where District is California.

select sum(POPULATION)
from CITY
where DISTRICT ='California';

9.Query the average population of all cities in CITY where District is California.

select avg(POPULATION)
from CITY
where DISTRICT='California';

10.Query the average population for all cities in CITY, rounded down to the nearest integer.

select ROUND(avg(POPULATION),0)
from CITY;

11.Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

select sum(POPULATION)
from CITY
where COUNTRYCODE='JPN';

12.Query the difference between the maximum and minimum populations in CITY.

select max(POPULATION)-min(POPULATION)
from CITY;

13.Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.

Note: CITY.CountryCode and COUNTRY.Code are matching key columns.

select sum(c.POPULATION) from CITY c
left join COUNTRY c1
on c.COUNTRYCODE=c1.CODE
where c1.CONTINENT ='Asia';

14.Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'.

Note: CITY.CountryCode and COUNTRY.Code are matching key columns.

select c.NAME
from CITY c
left join COUNTRY c1
on c.COUNTRYCODE=c1.CODE
where c1.CONTINENT='Africa';

15.

STUDENTS表：

Field	Type
ID	INTEGER
Name	String
Maks	INTEGER

1.Query the Name of any student in STUDENTS who scored higher than $Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.$

查询 STUDENTS 中任何得分高于 75 的学生的姓名。按每个名称的最后三个字符对输出进行排序。如果两个或多个学生的名字都以相同的最后三个字符结尾（即：Bobby.Robby 等），则按 ID 升序对他们进行二次排序。

select Name from STUDENTS
where Marks>75
order by right(Name,3),ID;

解题思路，按照每个名字的最后三个字符排序，order by 和right函数结合使用。

Employee表：

Field	Type
employee_id	INTEGER
name	String
months	INTEGER
salary	INTEGER

1.Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

select name 
from Employee
order by name;

2.Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than $per month who have been employees for less than months. Sort your result by ascending employee_id.$

$编写一个查询，打印员工姓名列表（即：名称属性），用于 Employee 中薪水大于每月且工作时间少于几个月的员工。按employee_id 升序对结果进行排序。$

select name
from Employee
where salary>2000 and months<10
order by employee_id;

3.We define an employee's total earnings to be their monthly salary*months $worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as 2 space-separated integers.$

$我们将员工的总收入定义为他们的月薪*工作月数，最大总收入定义为 Employee 表中任何员工的最大总收入。编写查询以查找所有员工的最大总收入以及拥有最大总收入的员工总数。然后将这些值打印为 2 个空格分隔的整数。$

select salary*months as earning,count(name)
from Employee
group by earning
order by earning desc
limit 1;

------------恢复内容开始------------

CITY表：

Field	Type
ID	number
NAME	VARCHAR2（17）
COUNTRYCODE	VARCHAR2（3）
DISTRICT	VARCHAR2（20）
POPULATION	number

1.Query all columns for all American cities in the CITY table with populations larger than `100000`. The CountryCode for America is `USA`.

select * from CITY
where POPULATION>=100000 and COUNTRYCODE='USA';

2.Query the NAME field for all American cities in the CITY table with populations larger than `120000`. The CountryCode for America is `USA`.

select Name from CITY
where COUNTRYCODE ='USA' and POPULATION>=120000;

3.Query all columns (attributes) for every row in the CITY table.

select * from CITY;

4.Query all columns for a city in CITY with the ID `1661`.

select * from CITY
where ID =1661;

5.Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is `JPN`.

select * from CITY
where COUNTRYCODE='JPN';

6.Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is `JPN`.

select NAME
from CITY
where COUNTRYCODE='JPN'

7.Query a count of the number of cities in CITY having a Population larger than 10,000.

select count(NAME) 
from CITY
where POPULATION>100000;

8.Query the total population of all cities in CITY where District is California.

select sum(POPULATION)
from CITY
where DISTRICT ='California';

9.Query the average population of all cities in CITY where District is California.

select avg(POPULATION)
from CITY
where DISTRICT='California';

10.Query the average population for all cities in CITY, rounded down to the nearest integer.

select ROUND(avg(POPULATION),0)
from CITY;

11.Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

select sum(POPULATION)
from CITY
where COUNTRYCODE='JPN';

12.Query the difference between the maximum and minimum populations in CITY.

select max(POPULATION)-min(POPULATION)
from CITY;

13.Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.

Note: CITY.CountryCode and COUNTRY.Code are matching key columns.

select sum(c.POPULATION) from CITY c
left join COUNTRY c1
on c.COUNTRYCODE=c1.CODE
where c1.CONTINENT ='Asia';

14.Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'.

Note: CITY.CountryCode and COUNTRY.Code are matching key columns.

select c.NAME
from CITY c
left join COUNTRY c1
on c.COUNTRYCODE=c1.CODE
where c1.CONTINENT='Africa';

15.Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer.

给定 CITY 和 COUNTRY 表，查询所有大洲的名称 (COUNTRY.Continent) 及其各自的平均城市人口 (CITY.Population)，四舍五入到最接近的整数。

Note: CITY.CountryCode and COUNTRY.Code are matching key columns.

select c.Continent,FLOOR(avg(c1.population))
from COUNTRY c
join CITY c1
on c.CODE=c1.CountryCode
group by 1;

STATION表：

Field	Type
ID	number
CITY	VARCHAR2（21）
STATE	VARCHAR2（2）
LAT_N	number
LONG_W	number

1.Query a list of CITY and STATE from the STATION table.

select CITY,STATE
from STATION;

2.Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

从 STATION 查询具有偶数 ID 号的城市的 CITY 名称列表。以任意顺序打印结果，但从答案中排除重复项。

select DISTINCT(CITY)
from STATION
where mod(ID,2)=0;

3.Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

求表中 CITY 条目总数与表中不同 CITY 条目数之间的差值。

select COUNT(CITY)-COUNT(DISTINCT(CITY))
from STATION;

4.Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

用最短和最长的 CITY 名称查询 STATION 中的两个城市，以及它们各自的长度（即：名称中的字符数）。如果有多个最小或最大的城市，请选择按字母顺序排列的第一个城市。

方法1: where子句+limit

select CITY,length(CITY) from STATION
where length(CITY)>=ALL(select length(CITY) from STATION) or length(CITY)<=ALL(select length(CITY) from STATION)
order by 2 desc,1
limit 2;

解题思路：

方法2:union+limit

(select CITY,length(CITY) from STATION
order by 2 desc,1 desc
limit 1)
union
(select CITY,length(CITY) from STATION
order by 2,1
limit 1);

解题思路：两个表组合。

5.Query the list of CITY names starting with vowels (i.e., `a`, `e`, `i`, `o`, or `u`) from STATION. Your result cannot contain duplicates.

从 STATION 查询以元音开头的 CITY 名称列表（即 a.e.i.o 或 u）。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where CITY LIKE'a%' or CITY LIKE'e%' or CITY LIKE'i%' or CITY LIKE'o%' or CITY LIKE'u%';

6.Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

从 STATION 查询以元音结尾的 CITY 名称列表（即 a.e.i.o 或 u）。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where CITY LIKE '%a' or CITY LIKE '%e' or CITY LIKE '%i' or CITY LIKE '%o' or CITY LIKE '%u';

7.Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

从 STATION 查询以元音开头和结尾的 CITY 名称列表（即 a.e.i.o 或 u）。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where (CITY LIKE '%a' or CITY LIKE '%e' or CITY LIKE '%i' or CITY LIKE '%o' or CITY LIKE '%u') and (CITY LIKE'a%' or CITY LIKE'e%' or CITY LIKE'i%' or CITY LIKE'o%' or CITY LIKE'u%');

8.Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

从 STATION 查询不能以元音开头的 CITY 名称列表（即 a.e.i.o 或 u）。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where CITY NOT LIKE 'a%' and CITY NOT LIKE 'e%' and CITY NOT LIKE 'i%' and CITY NOT LIKE 'o%' and CITY NOT LIKE 'u%';

9.Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

从 STATION 查询不能以元音结尾的 CITY 名称列表（即 a.e.i.o 或 u）。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where CITY NOT LIKE '%a' and CITY NOT LIKE '%e' and CITY NOT LIKE '%i' and CITY NOT LIKE '%o' and CITY NOT LIKE '%u';

10.Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

从 STATION 查询不以元音开头或不以元音结尾的 CITY 名称列表。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where (CITY NOT LIKE 'a%' and CITY NOT LIKE 'e%' and CITY NOT LIKE 'i%' and CITY NOT LIKE 'o%' and CITY NOT LIKE 'u%') or (CITY NOT LIKE '%a' and CITY NOT LIKE '%e' and CITY NOT LIKE '%i' and CITY NOT LIKE '%o' and CITY NOT LIKE '%u');

11.Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

从 STATION 查询不以元音开头和不以元音结尾的 CITY 名称列表。您的结果不能包含重复项。

select DISTINCT(CITY)
from STATION
where (CITY NOT LIKE 'a%' and CITY NOT LIKE 'e%' and CITY NOT LIKE 'i%' and CITY NOT LIKE 'o%' and CITY NOT LIKE 'u%') and (CITY NOT LIKE '%a' and CITY NOT LIKE '%e' and CITY NOT LIKE '%i' and CITY NOT LIKE '%o' and CITY NOT LIKE '%u');

12.Query the following two values from the STATION table:

The sum of all values in LAT_N rounded to a scale of 2 decimal places.
The sum of all values in LONG_W rounded to a scale of 2 decimal places.

select ROUND(sum(LAT_N),2),ROUND(sum(LONG_W),2)
from STATION;

13.Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 $and less than 137.2345 . Truncate your answer to 4 decimal places.$

select ROUND(sum(LAT_N),4)
from STATION
where LAT_N>38.7880 and LAT_N<137.2345;

14.Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than137.2345 $. Truncate your answer to 4 decimal places.$

select ROUND(max(LAT_N),4)
from STATION
where LAT_N<137.2345;

15.Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.3245. Round your answer to 4 decimal places.

select ROUND(LONG_W,4)
from STATION
where LAT_N<137.2345
order by LAT_N desc
limit 1;

16.Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7880 $. Round your answer to 4 decimal places.$

select ROUND(LAT_N,4)
from STATION
where LAT_N>38.7880
order by 1
limit 1;

17.

Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7880 $. Round your answer to decimal places.$

select ROUND(LONG_W,4)
from STATION
where LAT_N>38.7880
order by LAT_N
limit 1;

18.Weather Observation Station 18

Consider p1(a,b) $and p2(c,d) to be two points on a 2D plane.$

$a happens to equal the minimum value in Northern Latitude (LAT_N in STATION).$
$b happens to equal the minimum value in Western Longitude (LONG_W in STATION).$
$c happens to equal the maximum value in Northern Latitude (LAT_N in STATION).$
$d happens to equal the maximum value in Western Longitude (LONG_W in STATION).$

Query the Manhattan Distance between points $and and round it to a scale of 4 decimal places.$

select ROUND(max(LAT_N)-min(LAT_N)+max(LONG_W)-min(LONG_W),4)
from STATION;

19.Weather Observation Station 19

Consider p1 and p2 to be two points on a 2D plane where a,c are the respective minimum and maximum values of Northern Latitude (LAT_N) and b,d are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION.

将 p1 和 p2 视为 2D 平面上的两个点，其中 a,c 是北纬 (LAT_N) 的相应最小值和最大值，b,d 是 STATION 中西经 (LONG_W) 的相应最小值和最大值。

Query the following two values from the STATION table:

1.The sum of all values in LAT_N rounded to a scale of 2 $decimal places.$

2.The sum of all values in LONG_W rounded to a scale of 2 $decimal places.$

select ROUND(sum(LAT_N),2),ROUND(sum(LONG_W),2)
from STATION;

19.

STUDENTS表：

Field	Type
ID	INTEGER
Name	String
Maks	INTEGER

1.Query the Name of any student in STUDENTS who scored higher than $Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.$

select Name from STUDENTS
where Marks>75
order by right(Name,3),ID;

解题思路，按照每个名字的最后三个字符排序，order by 和right函数结合使用。

Employee表：

Field	Type
employee_id	INTEGER
name	String
months	INTEGER
salary	INTEGER

1.Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

select name 
from Employee
order by name;

$编写一个查询，打印员工姓名列表（即：名称属性），用于 Employee 中薪水大于每月且工作时间少于几个月的员工。按employee_id 升序对结果进行排序。$

select name
from Employee
where salary>2000 and months<10
order by employee_id;

select salary*months as earning,count(name)
from Employee
group by earning
order by earning desc
limit 1;

------------恢复内容结束------------

有关HackerRank第一趴--Basic Select的更多相关文章

ruby-on-rails - CarrierWave - PDF - 只选择第一页 - 2
我的Rails应用程序中安装了carrierwave。但是，当用户上传多页pdf时，我只希望应用程序获取文档中的第一页并将其转换为jpeg。这可能吗？用什么命令？这是我的uploader。#encoding:utf-8classImageUploader[200,300]##defscale(width,height)##dosomething#end#Createdifferentversionsofyouruploadedfiles:version:thumbdoprocess:resize_to_fill=>[150,210]process:convert=>:jpgdefful
ruby - 如何跳过 CSV 文件的第一行并将第二行作为标题 - 2
有没有办法跳过CSV文件的第一行，让第二行作为标题？我有一个CSV文件，第一行是日期，第二行是标题，所以我需要能够在遍历它时跳过第一行。我尝试使用slice但它会将CSV转换为数组，我真的很想将其读取为CSV，以便我可以利用header。最佳答案根据您的数据，您可以使用另一种方法和skip_lines-option此示例跳过所有以#开头的行require'csv'CSV.parse(DATA.read,:col_sep=>';',:headers=>true,:skip_lines=>/^#/#Markcomments!)do|
arrays - 在一行中选择数组的第一个和最后一个元素 - 2
我的任务是从数组中选择最高和最低的数字。我想我很清楚我想做什么，但只是努力以正确的格式访问信息以满足通过标准。defhigh_and_low(numbers)array=numbers.split("").map!{|x|x.to_i}array.sort!{|a,b|ba}putsarray[0,-1]end数字可能看起来像"80917234100"，要通过，我需要输出"9234"。我正在尝试putsarray.first.last，但一直无法弄明白。最佳答案有Array#minmax完全满足您需要的方法:array=[80,
ruby-on-rails - Ruby 或 Rails 有只将第一个字符大写的方法吗？ - 2
或者好像我必须自己写方法？(保持DHA不变):ruby-1.9.2-p180:001>s='omega-3(DHA)'=>"omega-3(DHA)"ruby-1.9.2-p180:002>s.capitalize=>"Omega-3(dha)"ruby-1.9.2-p180:003>s.titleize=>"Omega3(Dha)"ruby-1.9.2-p180:005>s[0].upcase+s[1..-1]=>"Omega-3(DHA)" 最佳答案如果我的回答只是垃圾，我深表歉意(我不做ruby)。但我相信我已经为您找到了答
ruby - gsub 删除第一个逗号前的所有内容 - 2
我有这个字符串:auteur="comtedeFlandreetHainaut,Baudouin,Jacques,Thierry"我想删除第一个逗号之前的所有内容，即在这种情况下保留“Baudouin,Jacques,Thierry”试过这个:nom=auteur.gsub(/.*,/,'')但这会删除最后一个逗号之前的每个逗号，只保留“Thierry”。最佳答案 auteur.partition(",").last#=>"Baudouin,Jacques,Thierry" 关于rub
ruby-on-rails - Order Hash 并删除第一个键值对 - 2
我有一个以时间戳为键的哈希。hash={"2016-05-31T22:30:58+02:00"=>{"path"=>"/","method"=>"GET"},"2016-05-31T22:31:23+02:00"=>{"path"=>"/tour","method"=>"GET"},"2016-05-31T22:31:05+02:00"=>{"path"=>"/contact_us","method"=>"GET"}}我订购了这个系列并得到了第一双这样的:hash.sort_by{|k,_|k}.first.first但是我该如何删除它呢？删除方法requiresyou知道key的准确
arrays - 字符串数组中字符串第一部分的总和 - 2
我有一个字符串数组，我需要从中提取第一个单词，将它们转换为整数并获得它们的总和。示例:["5Apple","5Orange","15Grapes"]预期输出=>25我的尝试:["5","5","15"].map(&:to_i).sum 最佳答案我从你的问题中找到了答案。["5Apple","5Orange","15Grapes"].map(&:to_i).sum在数组中，如果存在任何整数可转换值，那么它将自动转换为整数。关于arrays-字符串数组中字符串第一部分的总和，我们在Sta
ruby-on-rails - Rails 3 : Looping through array of objects, 忽略数组中的第一个对象？ - 2
在我看来，我正在尝试显示一个对象表，这是我的代码:CategoriesCBB's">然而这是抛出一个错误说:can'tconvertCapabilityBuildingBlockintoArray关系是正确的，错误来self尝试在此处减去数组的第一个对象的行:有什么方法可以忽略数组中的第一个对象来遍历数组吗？谢谢最佳答案尝试使用Array.drop-http://www.ruby-doc.org/core/classes/Array.html#M000294 关于ruby-on-ra
ruby-on-rails - 我如何跳过前三行而不是 FasterCSV 中的第一行 - 2
我正在使用FasterCSV我正在循环使用这样的foreachFasterCSV.foreach("#{Rails.public_path}/uploads/transfer.csv",:encoding=>'u',:headers=>:first_row)do|row|但问题是我的csv将前3行作为标题...有什么方法可以使fasterCSV跳过前三行而不是仅跳过第一行？？最佳答案不确定FasterCSV，但在Ruby1.9标准CSV库(由FasterCSV制作)中，我可以执行以下操作:c=CSV.open'/path/to/
Ruby 删除数组的第一个索引 - 2
我有一个数组。我需要保留除索引0处的元素以外的所有内容。此时我的大脑被炸毁了。我整天都在编程。任何帮助都会很棒。谢谢! 最佳答案使用Array#shift方法，它完全符合您的要求:a=[1,2,3]a.shift#=>1a#=>[2,3] 关于Ruby删除数组的第一个索引，我们在StackOverflow上找到一个类似的问题： https://stackoverflow.com/questions/11783005/

HackerRank第一趴--Basic Select

CITY表：

1.Revising the Select Query I

2.Revising the Select Query II

3.Select All

4.Select By ID

5.Japanese Cities' Attribute

6.Japanese Cities' Name

7.

Query a count of the number of cities in CITY having a Population larger than 10,000.

8.Query the total population of all cities in CITY where District is California.

9.Query the average population of all cities in CITY where District is California.

10.Query the average population for all cities in CITY, rounded down to the nearest integer.

STUDENTS表：

1.Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.

Employee表：

1.Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

CITY表：

1.Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

2.Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

3.Query all columns (attributes) for every row in the CITY table.

4.Query all columns for a city in CITY with the ID 1661.

5.Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

6.Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

7.Query a count of the number of cities in CITY having a Population larger than 10,000.

8.Query the total population of all cities in CITY where District is California.

9.Query the average population of all cities in CITY where District is California.

10.Query the average population for all cities in CITY, rounded down to the nearest integer.

STATION表：

1.Query a list of CITY and STATE from the STATION table.

2.Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

3.Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

4.Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

5.Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.

6.Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

7.Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

8.Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

9.Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

10.Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

11.Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

18.Weather Observation Station 18

19.Weather Observation Station 19

STUDENTS表：

1.Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.

Employee表：

1.Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

有关HackerRank第一趴--Basic Select的更多相关文章

随机推荐

1.Query the Name of any student in STUDENTS who scored higher than $Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.$

1.Query all columns for all American cities in the CITY table with populations larger than `100000`. The CountryCode for America is `USA`.

2.Query the NAME field for all American cities in the CITY table with populations larger than `120000`. The CountryCode for America is `USA`.

4.Query all columns for a city in CITY with the ID `1661`.

5.Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is `JPN`.

6.Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is `JPN`.

5.Query the list of CITY names starting with vowels (i.e., `a`, `e`, `i`, `o`, or `u`) from STATION. Your result cannot contain duplicates.

1.Query the Name of any student in STUDENTS who scored higher than $Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.$