[Solved] Following Mysql Query Create Function Returns Nth Value Table Select Name Sum Price Quanti Q37295694

From the following mySql query create a function that returns anth value of a table:

SELECT name, (SUM(price * quantity)) AS TotalPrice

FROM Items NATURAL JOIN Inventory

GROUP BY name

ORDER BY (TotalPrice) DESC

LIMIT 1, OFFSET 1;

Shema:

Inventory(name: String,item:String,quantity:integer)

Items(item: String, brand: String, price:double)

Expert Answer

---

Answer to From the following mySql query create a function that returns a nth value of a table: SELECT name, (SUM(price * quantity… . . .