Question: Write in SQL Queries and please DO NOT use JOIN or SUBQUERIES. FK-Account amount) Suppose you work at a bank as a data analyst. Your

Write in SQL Queries and please DO NOT use JOIN or SUBQUERIES.

Write in SQL Queries and please DO NOT use JOIN or SUBQUERIES.

FK-Account amount) Suppose you work at a bank as a data analyst.

FK-Account amount) Suppose you work at a bank as a data analyst. Your main job is to analyze the data stored in their database. The database has five tables, whose schema is shown as below. Primary keys attributes are underlined and foreign keys are noted in the superscript. Customer = {customerID, firstName, lastName, income, birthDate} Account = {accNumber, type, balance, branchNumberFK-Branch Owns = {customerIDFK-Customer accNumber FK-Account Transaction = {transNumber, accNumber" Employee = {ssn, firstName, lastName, salary, branchNumberFK-Branch} Branch = {branchNumber, branchName, managerSSNFK-Employee, budget} Notes. The customerID attribute (Customer) is a unique number that represents a customer, it is not a cus- tomer's SSN The accNumber attribute (Account) represents the account number The balance (Account) attribute represents the total amount in an account The type (Account) attribute represents the type an account: checking, saving, or business The transNumber attribute (Transactions) represents a transaction number, combined with account number it uniquely identify a transaction 10. Return customer ID, income, account numbers and branch numbers of customers with income greater than $90,000 who own an account at both London and New York branches, order by customer ID then account number. The result should contain ALL the account numbers of customers who meet the criteria, even if the account itself is not held at London or New York. 11. Return customer ID, types, account numbers, and balances of all business and savings accounts owned by customers who own at least one business account or at least one savings account, order by customer ID, then type, then account number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!