Answer the following questions about the database using SQL Statements. For each Question, please use an Alias for the table name and include your initials as one of the Aliases. Please only submit the SQL Statements for the answers, feel free to use this

profileFrenchienoire
Home>Homework Answsers>Information Systems homework help

 

  1. What customer addresses are on a "Lane or Ln?"

  2. What's the address to all businesses that were incorporated after Jan 1, 2000?

  3. How many individuals were born after 1970? 

  4. What's the average available and pending balance for all accounts at each Branch? (use Group by)

  5.  Which accounts have a difference between their Available and Pending Balance?

  6. Which employees does Paula Roberts Supervise?

  7. How many employees work at each Branch? 

  8. Write an SQL Statement to add a new teller to Headquarters and an IT Manager to headquarters. MAke up the information for the other columns.

  9. Write an SQL Statement to add a Database Administrator to the headquarters staff, please use your name for this statement. 
  • 8 years ago
  • 10
Report issue
Answer(1)
profile
FLOVODOH
4.6 (699)
4.0 (31)
Chat

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    sql.zip