d Karachi 20,000 01 02 Sanaullah Peshawar 30,000 02 03 Imran
Consider you have the following 2 tables.
Employee_Table
Employee_ID Employee_Name Address Salary in
(Rs)
Department_id
01 Arshad Karachi 20,000 01
02 Sanaullah Peshawar 30,000 02
03 Imran Peshawar 110,000 02
04 Asfahan Peshawar 95,000 01
05 Ayesha Peshawar 95,000 01
Dept_Table
Dept_ID Dept_Name
01 Finance
02 IT
03 HR1. Write SQL Query for finding/displaying names and ids of employees
whose salary is greater than 50,000 RS in ascending order of their salary
2. Create a View showing Employee names, their department name and
salary of Employees from Peshawar only. Salary column should be
displayed as ‘Total Salary’
3. Delete employees’ data who are from Karachi.
4. Write SQL Right Outer Join query and its output on the given two tables.
Step by step
Solved in 2 steps