Database: join and union

Part I- SQL JOIN & UNION 1. For all the transactions whose amounts exceed $110, display transaction ID, the amount of the transaction, customer ID, and the available balance in the account associated with the transaction. 2. Find how many accounts were opened in each branch. Display the branch name and the number of accounts only if the branch has more than 5 accounts. 3. For a the transactions, retrieve transaction ID, amount of the transaction, customer ID, customer full mailing address and the available balance of the accounts associated with the transactions. (Hint: join 3 tables, use concat for full mailing address) 4. Retrieve the first name and last name of all presidents from the employee table and the officer table. (Hint: UNION) Part II - Client-Server Architecture For this part, use the world database in ist274csusb server. 1. Find the country codes of countries where population is over 200,000,000 or where Spanish is spoken by over 95% of the population. (Hint: UNION) 2. Retrieve the country name and life expectancy of countries that speak Chinese as an official language. (Hint: Use subquery or JOIN)