задание 1
SELECT Category
FROM Categories
ORDER BY Category;
задание 2
SELECT Shop, Spending_Date, Amount
FROM Spendings ORDER BY Amount DESC;
задание 3
SELECT Goods_Name, Cost
FROM Goods, Goods_Spendings
WHERE Goods.Goods_ID = Goods_Spendings.Goods_ID
ORDER BY Goods_Name, Cost DESC;
задание 4
SELECT Goods_Name, Shop, Cost
FROM Goods, Goods_Spendings, Spendings
WHERE Goods.Goods_ID = Goods_Spendings.Goods_ID
AND Goods_Spendings.Spending_ID = Spendings.Spending_ID
And Cost > 200
ORDER BY Goods_Name, Shop, Cost DESC;