I JUST NEED THE QUERIES NOT THE TABLE CREATION:

6. Get customer names for customers who have an account in every bank except Royal and France.

7. Get customer names for customers who have an account in every bank that Clark banks without using NOT EXISTS (B MINUS A).

8. Get customer names for customers who have an account in every bank that Clark banks using NOT EXISTS (B MINUS A).

9. Get customer names for customers who bank in more than bank without using grouping and aggregate function.

10. Get customer names for customers who bank in more than bank using grouping and aggregate function.

11. Get complete information of each customer such that when the customer has an bank account, list bank detail and balance, when the customer does have an account, just list the customer information.

12. Get customer names and total quantity supplied. If the customer does not customer any parts, leave it null.

Part 1. SQL Queries (60 marks) Use Oracle-VM SQL Data Definition Language to create the following Bank-and-Customer database. You should properly define primary keys and foreign keys and then use SQL Query Language to express the following queries. In the document that you submit, you should have the question with its number, SQL query, and query result generated by Oracle-VM for each question. Each query is 3 marks and the result is 2 marks. Bank BName City Account CH B# Balance BI England London B2 America New York00 B3 Roval B4 France Paris CI BI 1000 |C11B3| 3000 C2 B 2000 C1 B2 2000 C1 B3 3000 C1 B4 4000 -Toronto Customer C#Name Ag C1 Adams 20 London C2 Blake 30 Paris C2B2-3000 e City C2 B3 4000 I |c3BII 3000 B2 4000 C3 Clark 25 Paris C5 Smith 30 Toronto! C4 B1 4000 C4 Jones 20 London I- C4 B25000