Challenge: Data Manipulation
Try a hands-on exercise to test your knowledge and understanding of data manipulation language.
We'll cover the following...
We'll cover the following...
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: