SELECT customername,balance,creditlimit FROM customer where balance > (creditlimit/2)

/*getting the customer name, balance and credit limit from the customers whose balance is greater than half the creditlimit