we need a freelancer to help us with two mysql queries and return results as required.
REQUEST 1 ,
we attach table structure, insert records, query we currently use ( which does not return records we need ) , an image where we have mark in red records we would like to return .
Actually that is a table from which we get sum of values , BUT we only need latest updated files to be returned .
we attach table structure with some data and query we currently use .
We need to get sum from varchar fields which contains the word "ERROR" now we count the fields to get a result for our statistics but we need to SUM instead of count without changing the varchar fields from varchar to decimal .