After studying the first 25 slides of chapter 5:
Run the following query
- Create a table EMPLOYEE (DDL command)
- Columns (ID INT, FNAME VARCHAR(25),LNAME(VARCHAR(25),AGE INT, SALARY INT, BONUS (OPTIONAL))
- ID PRIMARY KEY.
- INSERT 4 RECORDS (YOU CHOOSE)
- SELECT EVERYTHING FROM THE TABLE
- SELECT ONLY THE FIRSTAME,LASTNAME AND SALARY OF ALL EMPLOYEES.
- I suggest you run this queries in the SQL Software before submitting them.