select
    member_name,
    status,
    SUM(amount * unit_price) as costs
from
    Payments
    INNER JOIN FamilyMembers ON Payments.family_member = FamilyMembers.member_id
WHERE
    YEAR(date) = 2005
GROUP BY
    member_name,
    status

SELECT member_name
FROM FamilyMembers
WHERE birthday=
    (SELECT MIN (birthday)
    FROM FamilyMembers)

SELECT DISTINCT status
FROM FamilyMembers
INNER JOIN Payments
    ON Payments.family_member=FamilyMembers.member_id
INNER JOIN Goods
    ON Payments.good=Goods.good_id
WHERE good_name="potato" 

SELECT status,
         member_name,
        (amount * unit_price) AS costs
FROM FamilyMembers
INNER JOIN Payments
    ON Payments.family_member=FamilyMembers.member_id
INNER JOIN Goods
    ON Payments.good=Goods.good_id
INNER JOIN GoodTypes
    ON GoodTypes.good_type_id=Goods.type
WHERE good_type_name="entertainment"

SELECT good_name
FROM Goods
INNER JOIN Payments
    ON Payments.good=Goods.good_id
GROUP BY  Payments.good
HAVING COUNT(Payments.good)>1

SELECT member_name
FROM FamilyMembers
WHERE status='mother'

SELECT good_name,
         unit_price
FROM Payments
INNER JOIN Goods
    ON Payments.good=Goods.good_id
WHERE unit_price=
    (SELECT MAX(unit_price) AS unit_price
    FROM Payments
    INNER JOIN Goods
        ON Payments.good=Goods.good_id
    INNER JOIN GoodTypes
        ON Goods.type=GoodTypes.good_type_id
    WHERE good_type_name="delicacies")