Database using SQL Statements

  1. 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 template as an answer sheet. 
    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?
  2. 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.
  3. Write an SQL Statement to add a Database Administrator to the headquarters staff, please use your name for this statement.

Submit answer sheet to these problems.

 

Last Updated on February 11, 2019 by EssayPro