Insert all those records of table Accounts into table pending where amt_outstanding

Q. Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000.

Answer =

Query if you have already created table Pending :-

Insert into Pending
Select * from Accounts where amt_outstanding > 10000 ;

Query if you have not created Pending table in your database :-

Create table Pending Select * from Accounts where amt_outstanding > 10000 ;