Pull data from table

I have a table full of mortgage rates and want to show a row at the top of the best rate (or lowest rate) from each column, here is the page I am currently doing this and the page I am trying to re-create it in my new wordpress site:

Old Site: https://www.lowestratecanada.com/canada-mortgage-rates
New Site: https://new.lowestratecanada.com/rates/

I also want to be able to pull this rate data and post it on many other websites that I manage but only update this one table. I have done this in the past using MySQL and PHP but converting all my old sites to WordPress and having trouble getting this to work. I am clearly not advanced in this type of code. Is this possible using the TablePress plugin? On the old website I used code like this…

<?php
mysql_connect(“mysql”, “ratesheetdb”, “RSdata!!692”) or die(“Can not connect.”);
mysql_select_db(“ratesheet”) or die (“Can not find database.”);
?>

$variable_sql = “SELECT * FROM rates_main WHERE variable_rate != ” && variable_rate != ‘-‘ ORDER BY variable_rate ASC LIMIT 1″;
$variable_result = mysql_query($variable_sql);
$variable_row = mysql_fetch_object($variable_result);

<? echo $variable_row->variable_rate; ?>

This worked great in my old designs but can’t get it to work within my new wordpress designs so trying to use TablePress to recreate this?

https://www.ads-software.com/plugins/tablepress/