SQL Practice -

Submit SQL statements

Using the tables (cs3350.branches, cs3350.transactions, cs3350.employees, cs3350.customers)

CS3350.EMPLOYEES

( EMPLOYEE_ID NUMBER,

BRANCH NUMBER,

FIRST_NAME VARCHAR2,

LAST_NAME VARCHAR2

)

CS3350.CUSTOMERS

( CUSTOMER_ID NUMBER,

PRIMARY_BRANCH NUMBER,

FIRST_NAME VARCHAR2,

LAST_NAME VARCHAR2

)

CS3350.TRANSACTIONS

( TRANSACTION_ID NUMBER,

CUSTOMER_ID NUMBER,

BRANCH_NUMBER NUMBER,

AMOUNT NUMBER(6,2),

TRANSACTION_DATE DATE

)

CS3350.BRANCHES

( BRANCH_NUMBER NUMBER,

STREET VARCHAR2,

CITY VARCHAR2,

ZIPCODE VARCHAR2

)

write Select SQL statements to retrieve the following information.

1. The first and last name of all employees at branch_id - 12349, listed in alphabetical order by last name.

2. The first and last name of the employees with the following employee_ids - 2,3,5,7,11,13 listed in alphabetical order by last name.

3. All street addresses, city, and zip_code and the number of employees at that branch listed in order by most employees to the least, then by street address.

4. The street address, city and zip_code of all branches with 3 or more customers listing that branch as their primary branch listed in order by street address.

5. The date as Month Name Day, Year (January 24, 2017), and amount of all transactions performed on a Tuesday listed in ascending date order.