What is the minimum transaction amount?
select min(amount_of_transaction) from transactions
How many transactions have an amount smaller than 3000?
select count(amount_of_transaction) from transactions where amount_of_transaction < 3000
Please show the sale details and dates of transactions with amount smaller than 3000.
select t1.sales_details, t2.date_of_transaction from sales as t1 join transactions as t2 on t1.sales_transaction_id = t2.transaction_id where t2.amount_of_transaction < 3000