Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT [email protected] | 2010-06-18 [email protected] [email protected] 2010-03-08 [email protected] 2013-01-28...


Write SQL Queries for following Employee table :<br>EMPLOYEE_ID Name<br>EMAIL<br>HIRE_DATE SALARY DEPARTMENT<br>Juniad@abc.com | 2010-06-18<br>Irfan@abc.com<br>Hassan@abc.com 2010-03-08<br>Fahad@abc.com 2013-01-28<br>110000.00 CS<br>100000.00 Sales<br>88000.00 Marketing<br>101<br>Juniad<br>Irfan<br>102<br>2011-04-16<br>103<br>Hassan<br>104<br>Fahad<br>90000.00<br>Sales<br>105<br>Husnain Hus@abc.com<br>2012-01-28<br>55000.00<br>ES<br>1. Write a query to display sales and marketing department data.<br>2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary).<br>3. Write a query to get the total salaries payable to employees.<br>4. Write a query to get the average salary and number of employees in the employees table.<br>5. Write a query to select first 2 records from a table.<br>6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.<br>

Extracted text: Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT [email protected] | 2010-06-18 [email protected] [email protected] 2010-03-08 [email protected] 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain [email protected] 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here