Ich soll in Maria DB eine View erstellen, die den Durchschnittspreis einer Buchung pro Herkunftsland der Passagiere beinhaltet.
CREATE VIEW booking_average (passengerdetails.country) AS
SELECT
AVG(price_country)
FROM
passengerdetails
JOIN passenger ON (
passengerdetails.passenger_id = passenger.passenger_id
)
JOIN on (
passenger.passenger_id = booking.passenger_id
)
GROUP BY
passengerdetails.country
CREATE VIEW booking_average (passengerdetails.country) AS
SELECT
AVG(price_country)
FROM
passengerdetails
JOIN passenger ON (
passengerdetails.passenger_id = passenger.passenger_id
)
JOIN on (
passenger.passenger_id = booking.passenger_id
)
GROUP BY
passengerdetails.country