Junior — Middle+
SQL query returning current interest rates for each payout point
livecode
Task condition
Create a query that displays the latest known percentage values for all points of issue.
create table pp_tariff
(
tariff_id bigserial,
created_at timestamp default now(),
point_id bigint,
rate numeric
);
List of points: 1,2,3,4,5,6
Example records in the table: 1 - 02.10 - 1 - 2% 2 - 02.10 - 2 - 2% 3 - 02.10 - 3 - 2% 4 - 02.10 - 4 - 2% 5 - 02.10 - 5 - 2% 6 - 03.10 - 1 - 3% 7 - 03.10 - 4 - 1% 8 - 03.10 - 2 - 5%