Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. Write a query to display name, job, hiredate and employee number of each employee. Query: EmpName All Ahmed Al Braa Mohammad Nasser Abdur
a. Write a query to display name, job, hiredate and employee number of each employee. Query: EmpName All Ahmed Al Braa Mohammad Nasser Abdur Rehman Yassen Omar Bilal Sultan Saad Abdullah All Ahmed Al Bras Mohammad Nasser Abdur Rehman job SALESMAN CLERK MANAGER MANAGER ANALYST CLERK CLERK EmpName- Total Salary Yassen Omar Bilal Sultan Saad Abdullah SALESMAN ANALYST ANALYST SALESMAN PRESIDENT Deptno b. Write a query to display all total salary of each employee. Query: 6000 4700 11500 12000 9200 5300 6500 5000 10400 12000 8500 35000 hiredate DeptName 3/26/2000 1/16/2014 2/16/2010 4/16/2003 7/16/2010 7/10/2009 1 ACCOUNTING 2 SALES 3 OPERATIONS 4 RESEARCH 7/6/2012 7/1/2010 11/16/2013 7/1/1999 3/3/2015 7/3/1990 c. Write a query to display all column of department table. Query: empno loc Riyadh Jeddah Madinah Taif 1231 1234 1236 2311 2342 2442 2456 3413 4324 5213 7766
Step by Step Solution
★★★★★
3.42 Rating (174 Votes )
There are 3 Steps involved in it
Step: 1
Answer a SELECT EmpName job hiredate empno FROM employe...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