Prova SQL2

View as PDF

View the database schema Submit solution

Points: 1
Time limit: 2.0s
Memory limit: 62M

Author:
Problem type
BD - Selects
Category
Bases de Dades
Allowed languages
Text

You know what you're doing.

(enunciat real, selecciona tots els product_name i unit_price de la taula products que tinguin preu major a 20 )

SELECT product_name, unit_price FROM products WHERE unit_price > 20 ORDER BY unit_price DESC;


Comments

There are no comments at the moment.