2 votes

Queries in MYSQL

enter the description of the image here

What would be the appropriate query for this?

List the author of the most expensive book

 SELECT MAX(PrecioCompra) from libros (select idAutor from Autoreslibros);

I tried that

List the author of the cheapest book

 SELECT MIN(PrecioCompra) from libros (select idAutor from Autoreslibros);

HolaDevs.com

HolaDevs is an online community of programmers and software lovers.
You can check other people responses or create a new question if you don't find a solution

Powered by:

X