How is the abandonment rate % Derived?

Hi There,

I am investigating the PIWIK backend in MySQL and am wondering how the program arrives at the Ecommerce Cart abandonment rate ie (“Visits with Abandoned Cart”, “Revenue Left in Cart” and “Visits with abandoned cart”). Is it possible to write a database query to retrieve this metric?

Thanks

Greg