SQL queries on Employee Database

Background

A series of SQL queries on the employee database to obtain information.

Queries Used

• Data Definition Language Statements:
  • ALTER
  • DROP
  • CREATE VIEW
  • DROP VIEW
• Data Manipulation Language Statements:
  • SELECT
  • APPEND
  • DELETE
  • UPDATE
  • JOIN
• Aggregate Functions:
  • SUM
  • COUNT
  • GROUP BY
  • WHERE