Challenge: Data Manipulation
Try a hands-on exercise to test your knowledge and understanding of data manipulation language.
Problem statement
There’s a table named Employee
that contains the information of the employees. It has the following columns.
empid
: This is the primary key of the table.empname
: This column contains the employee’s name.salary
: This column contains the employee’s salary.city
: This column contains the city of the employee.
Task 1
Write a query to insert the following data into the Employee
table: