🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 20:

Determinate Plane Coordinates

PostgreSQL
Determine the coordinates of the plane of flight 475 after half an hour from the moment of actual departure from the airport, assuming that the plane is constantly moving in a straight line at a constant speed.
Display the resulting coordinates in the current_coordinates column as an array.
Expected result Columns: 1 · Rows: 1
current_coordinates

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query