CS307 – Assignment 3: Queries and Window

$ 20.99
Category:

Description

1. Please find how many stations are there on line 3, not on line 4, and the latitude is above the average? 请求出在三号线上不在四号线上,并且纬度在平均之上的车站有多少个?

2. Please find out the most frequently-used letter of English names’ First letter of stations, and then give the ranking of the number of stations containing this letter by district (from high to low). When different districts have the same number , you can take the default order in postgresql as the order of these districts.
请找出所有地铁站的英文名首字母中出现频率最高的字母,然后按区给出含有这个字母的地铁站数量的排名(从高到低)。不同区含有相同数值的情况时,按照postgresql默认排序即可。

3. In Longhua, Baoan,and Nanshan 3 districts, please find the top three subway stations which has the most number of bus_lines connected. The order should be up to the giving district order, the number of bus_lines and the station_id.
请找出龙华、宝安、南山三个区内,拥有公交车接驳站最多的3个地铁站(排序根据district顺序:
Longhua->Baoan->Nanshan,公交站数量以及station_id)

4. Each subway line passes through a certain number of stations. As for the subway lines built so far, please output the line_id, opening time, number of subway stations passed by , as well as the change rate of the number of subway stations that each subway line passes through compared with the previous opening one (the result retains two decimal places).
每一条地铁线所经过的地铁站数目是一定的。请输出到目前为止的所有地铁线的id,开通时间,所经过的地铁站数,以及每一条地铁线相较于上一条建的地铁线所经过的地铁站数目的变化率(结果保留两位小数)。

Reviews

There are no reviews yet.

Be the first to review “CS307 – Assignment 3: Queries and Window”

Your email address will not be published. Required fields are marked *