Загрузка данных



SELECT *
FROM Spendings
WHERE Sum > 1000;

Сеня Козлитин, сегодня в 12:54
SELECT Shop, Sum
FROM Spendings
WHERE Spending_Date <= '2015-06-03';

Сеня Козлитин, сегодня в 12:54
SELECT Category
FROM Categories
WHERE Category_ID IN (1, 3, 4);

Сеня Козлитин, сегодня в 12:54
SELECT Shop, Spending_Date, Sum
FROM Spendings
WHERE Sum BETWEEN 1000 AND 2000;

Сеня Козлитин, сегодня в 12:54
SELECT Goods.Goods_Name, Goods_Spendings.Sum
FROM Goods
JOIN Goods_Spendings ON Goods.Goods_ID = Goods_Spendings.Goods_ID
WHERE Goods_Spendings.Sum > 500;