Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Emp_num Emp_Name Emp_Job Emp_Sal E101 Salman Analyst 6000 E102 Bushra Programmer 5000 E103 Madiha Web Designer 6000 E104 Batool ERD designer 4000 E105 Hameed Web
| Emp_num | Emp_Name | Emp_Job | Emp_Sal |
| E101 | Salman | Analyst | 6000 |
| E102 | Bushra | Programmer | 5000 |
| E103 | Madiha | Web Designer | 6000 |
| E104 | Batool | ERD designer | 4000 |
| E105 | Hameed | Web Designer | 3000 |
| E106 | Nini | Analyst | 2500 |
| E107 | Imtiaz | Web Designer | 6500 |
| E108 | Rashid | Programmer | 4000 |
| E109 | Muzzamil | ERD designer | 2000 |
- List all employees number, employees name and jobs from emp.
- List all employees number, employees name and jobs from emp whose salaries greater than 5,000.
- List all employees number, employees name and jobs from emp whose salaries less than 5,000.
- List all employees number, employees name and jobs from emp whose salaries between 1,000 to 5,000.
- List all employees number, employees name, jobs and salaries from emp.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
