This is my code:
SELECT USER.userName, COUNT(reservation.userID), SUM(price) PricePerUser FROM USER
JOIN reservation ON reservation.userID = USER.userID
JOIN venue ON venue.venueID = reservation.venueID
JOIN TIME ON reservation.timeID = TIME.timeID GROUP BY USER.[userName]
Aucun commentaire:
Enregistrer un commentaire