DECLARE @cust_id AS INT = xxx         -- ID клиента
SELECT TOP (1) CustomerID
	,TransactionDate
	,Amount
FROM Transactions
WHERE CustomerID = @cust_id
	AND Amount > 100
	AND TransactionDate < convert(DATE, getdate())
ORDER BY TransactionDate