below is the questions i need to solve using the above info

please i need 6 and 7 answered thank you

2. DROP DATABASE IF EXISTS Bank; CREATE DATABASE Bank; USE Bank; 3 4 5 6 DROP TABLE IF EXISTS transaction; DROP TABLE IF EXISTS customer; DROP TABLE IF EXISTS account; 7. 8 9 10 CREATE TABLE customer ( 11 name VARCHAR(20), 12 sex CHAR(1), 13 ssn CHAR(9) NOT NULL, 14 phone CHAR(15), 15 dob DATE, 16 address VARCHAR(58), 17 PRIMARY KEY(Ssn) 18 19 ); 28 21. CREATE TABLE account ( 22 number CHAR(16) UNIQUE NOT NULL, 23 open_date DATE, 24 type CHAR(20), 25 owner_ssn CHAR(9) NOT NULL, 26 PRIMARY KEY(number) 27 ); 28 29. CREATE TABLE transaction 30 id INT(20) UNIQUE NOT NULL, 31 amount DECIMAL (9,2), 32 tdate DATE, 33 type CHAR(10), 34 account_num CHAR(16), 35 PRIMARY KEY(id) 36 ); 37 38 37 46. INSERT INTO customer VALUE (John Adam', 'H', 522432341) (438) 321-2551 1587-11-15, NULL) INSERT INTO customer VALUE ('Alander Felix', 'M', 72402341) 2541) 321-0553", "1991-05-22, MULL), INSERT INTO customer VALUE (Andrew Willia', '61894272 (309) 32-1110, 1995-91-94), NULL); INSERT INTO customer VALUE (Ana Bert','', 8441922415, (205) 932-70001982-12-07 23 Boston Post Rd, West Haven, CT 515) 43 44. INSERT INTO account VALUE (1111222233331441, 2015-12-03', 'Checides851014272); 45 INSERT INTO account VALUE ( 2111222233332042", 2019-01-06",Savine, '512432341"); INSERT INTO account VALUE (3111222233333443', '2017-05-22', 'Checkins 144192241') INSERT INTO account VALUE (4111222233335444', '2016-04-116 'Checking', 724432341"); INSERT INTO account VALUE (51112222333394451 2015-11:15","Saving'724325410) 49. INSERT INTO transaction VALUE (1601, 202.50, 2017 10:15, 'Oposits 511123223323445) 50. INSERT INTO transaction VALUE (2002,100.00 2019-01:23 Deposit, 2111222233332012) 51. INSERT INTO transaction VALUE (1003, 200.00 2015-05-29, Deposit, 2111222333332642) 52. INSERT INTO transaction VALUE (1004,50.002019-02-29'eposit 2131222232332442') 53. INSERT INTO transaction VALUE (1005, 1000.00 2015-09-29 Deposit,3111223233333643) INSERT INTO transaction VALUE (1006, 202.50, 2019-08-23 withdraw,51112232333945) 35 - INSERT INTO transaction VALUE (1007, 58.00, 2019-05-235 Depost, 2111222233333443') 56. INSERT INTO transaction VALUE (1000. 50.00 2015-09-25 Deposit 11122323312042')) 57. INSERT INTO transaction VALUE (1000, -10.09, 2013-09-29,2111322233272402) 58. INSERT INTO transaction VALUE (1010, 50.29,2015 09:20epost, 211122233333544) 59 INSERT INTO transaction VALUE (2011, 120.00, 11. Deposit 11227233345) 60. INSERT INTO transaction VALUE (1012, 10:00,2019.09.15$ posit411232233335414) INSERT INTO transaction VALUE (101) 56000, 2010-06-23 Deposit 1611222233331441 62. INSERT INTO transaction VALUE (1014, 2000, 19-2111222233333445) 63. INSERT INTO transaction VALUE (1015,700.00 2010-01-26, 111122223311) 6. Find all accounts associated with 'Alexander Felix'. 7. For each account of the previous question, compute the Balance, and return a table that shows the account number. type, and balance for each account (hint: use UNION). 8. The list of customer names that have transactions greater than or equal to one thousand dollars. A) Answer this question using only nested queries (i.e., each select is over only one table)