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
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