Please post code and output code done in SQL

Suppose we have a part of a Bank database schema consisting of the relations $($the keys are in bold and

underlined$)$:

BRANCH$($branch$\_$name, City, Assets$)$

ACCOUNT$($account$\_$number, C$\_$SSN$,$ branch$\_$name, balance, account$\_$type, interest$\_$rate, overdraft,

B$\_$SSN$)$

CUSTOMER$($C$\_$SSN$,$ first$\_$name, last$\_$name, address$)$

CUSTOMER$\_$ACCOUNT$($C$\_$SSN$,$ account$\_$number, date$)$

TRANSACTION$\_$INSTANCE$($transaction$\_$code, transaction$\_$number, account$\_$number, date, time,

amount$)$ TRANSACTION$($transaction$\_$code, transaction$\_$type, description, charge$)$

BANKER$($B$\_$SSN$,$ first$\_$name, last$\_$name, address, start$\_$date, phone, manager SSN$)$

$$

$$

$$

Express the following queries in SQL$.$

Create a small database using any DBMS you know and populate the database with enough data for you to be able to run the queries and show answers.

You will have to submit the answers to thequeries and the resultt obtained

$1.$ List the accounts with no transaction since September $1$st $2024.$

for

these

$2.$ List customers $($C$\_$SSN$,$ first$\_$name, last$\_$name$)$ of the $$Broad Street$$ branch.

queries.

$3.$ List customers $($C$\_$SSN$,$ first$\_$name, last$\_$name$)$ who have an account in Newark $($one or

more accounts$).$

$4.$ List customers $($C$\_$SSN$,$ first name, last$\_$name$)$ who have no account in Newark.

$5.$ List customers $($C$\_$SSN$,$ first$\_$name, last$\_$name$)$ who have accounts in every branch in

Newark.

$6.$ List customers $($C$\_$SSN$,$ first$\_$name, last$\_$name$)$ who have more than one account in the

$$NJIT$$ branch.

$7.$ List the name of the employee who has the maximum number of customers in charge.

$8.$ List for each account the number of transactions made since September $1$st $2024.$

$9.$ List the average number of transactions per day since September $1$st $2024.$