You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
602 B
28 lines
602 B
-- Query 8: Liste des consommations classées par ordre alphabétique sur le libellé
|
|
SELECT
|
|
cns.libcons as 'libellé',
|
|
cns.numcons as 'numéro',
|
|
cns.prixcons as 'prix'
|
|
FROM consommation cns
|
|
ORDER BY cns.libcons;
|
|
|
|
/* == RESULT ==
|
|
"Libellé","Numéro","Prix"
|
|
"Bière 25 Cl",107,2.5
|
|
"Bière 33 Cl",108,3
|
|
"Bière 50 Cl",110,4.5
|
|
"Bière Blonde",200,4.5
|
|
"Bière pression",106,2.5
|
|
"Café",100,1
|
|
"Café crème",102,1.6
|
|
"Café double",101,2
|
|
"Chocolat",105,2
|
|
"Coca Cola",130,2
|
|
"Cocktail",300,8
|
|
"Fruit pressé",121,3
|
|
"Jus de fruit",120,2
|
|
"Jus de tomate",150,2
|
|
"Orangina",124,2.7
|
|
"Perrier",122,2.5
|
|
*/
|