Assignment
Answer The Following Questions About The Database Using SQL Statements.
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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Learning-SQL-MySQL-Script.rar