1. Write a query to create a table employee with Emp No (4), Ename, Department, and Salary and insert the following instance. . Emp No 001 Ename Levina Department Developer Programmer Analyst Testing...


Solve database question


1. Write a query to create a table employee with Emp No (4), Ename, Department, and Salary<br>and insert the following instance. .<br>Emp No<br>001<br>Ename<br>Levina<br>Department<br>Developer<br>Programmer<br>Analyst<br>Testing<br>Developer<br>Admin<br>Salary<br>10000<br>002<br>Livin<br>15000<br>Liviya<br>Johanna<br>003<br>20000<br>004<br>10000<br>005<br>Johan<br>15000<br>006<br>Jinu<br>25000<br>007<br>Jeno<br>Admin<br>25000<br>008<br>Prabin<br>Analyst<br>15000<br>2. Write a Query to Alter the column EMPNO (4) TO EMPNO (6).<br>3. Write a query to find the employee whose salary is between 0 to 10000<br>4. Write a query to find the name of customer whose name is like

Extracted text: 1. Write a query to create a table employee with Emp No (4), Ename, Department, and Salary and insert the following instance. . Emp No 001 Ename Levina Department Developer Programmer Analyst Testing Developer Admin Salary 10000 002 Livin 15000 Liviya Johanna 003 20000 004 10000 005 Johan 15000 006 Jinu 25000 007 Jeno Admin 25000 008 Prabin Analyst 15000 2. Write a Query to Alter the column EMPNO (4) TO EMPNO (6). 3. Write a query to find the employee whose salary is between 0 to 10000 4. Write a query to find the name of customer whose name is like "Jo%" 5. Write a query to find the average salary of the Employees 6. Write a query to lists the number of Employee in cach Department, sorted high to low Points to consider before making the final submission Screen shot of the all the execution should be attached below cach question.

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here