dnviti/apollinare-catering-software
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
apollinare-catering-software/docs/views/GET_COSTO_OSPITI_EVT.md
dnviti 7dd4ea08e1 extracted objects
2025-12-17 13:02:12 +01:00

380 B
Raw Permalink Blame History

GET_COSTO_OSPITI_EVT

Colonne

Colonna Tipo
ID_EVENTO NUMBER
NUMERO NUMBER
COSTO NUMBER

Definizione

CREATE OR REPLACE VIEW GET_COSTO_OSPITI_EVT AS
SELECT edr.ID_EVENTO, sum(edr.numero) as numero, SUM(edr.numero * (edr.COSTO - (edr.COSTO*(edr.sconto/100)))) AS costo
FROM EVENTI_DET_OSPITI edr
GROUP BY edr.ID_EVENTO