I need the Oracle-VM SQL Query for the following queries. Please help with as many possible. Please do not give me answers in ALG (relational algebra) or TRC (Tuple relational calculus).

Get the name of the customer who banks in Royal or America bank.

Get the customer name/bank name pairs such that the indicated customer has an account in the indicated

bank.

Get the customer name/bank name pairs such that the indicated customer does not an account in the

indicated bank.

Get the name of the customer who has an account in every bank except France Bank.

Get the name of the customer who has an account in every bank that Clark banks without using NOT EXISTS (B MINUS A).

Get the name of the customer who has an account in every bank that Clark banks using NOT EXISTS (B MINUS A).

Get the name of the customer who banks only in the banks that Clark banks.

Get the name of the customer, the number of banks he/she banks, and total balance he/she has.

Get complete information of each customer such that when the customer has an bank account, list bank

detail and balance; when the customer does not have an account, just list the customer information.

Get customer names and total balance in all banks. If the customer has no account, leave it null.

B Name City Bl England London B2 America New York B3 Royal Toronto Customer Name Age City C1 Adams 20 London 30 Paris C4 Your Lastname 20 London C5 Smith 30 Toronto