Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

Write the SQL command to revoke user Stetsons privilege.

Answered: 1 week ago