Sobes.tech
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%