my $sql="SELECT idNum, (First(price)-Last(price)) AS difference ,Min(dateCreated) AS minDate, Max(dateCreated) AS maxdate, Last(mobile) AS lastMobile, Last(contents) AS lastContents,(( (First(price)-Last(price)) /First(price) )*100) AS percentChange , Last(price) AS lastPrice, Last(state) AS lastState, Last(contact), Last(year) FROM carAdds GROUP BY idNum HAVING (( Last([year]))>=$yearmodel) ORDER BY (( (First(price)-Last(price)) /First(price) )*100) DESC";