Написать два запроса на SQL и XQuery
A web page is required that shows the average number of bikes available at TFL bike stations at a particular time of day as a proportion of the station capacity. The page connects to the online tflBikes database and generates HTML content in real time using PHP and MySQL. It must contain a table with rows representing each station that is within a square cell of a particular size that is centred on the focus station. Each row of the table must show four items of data from left to right in this order:
- the average number of bikes available at the specified time of day;
- this number as a percentage of station capacity;
- the station name;
- the postcode.
В базе указаны не метры, а широта и долгота!
2) XML db: https://www.sendspace.com/file/u70mw5
The HTML that is generated must contain a list of all stations that have
- the same number of bikes currently docked, and
- at least as many empty docks as Emperor's Gate, South Kensington.