a. Write a query to display name, job, hiredate and employee number of each employee. Query:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Answer a SELECT EmpName job hiredate empno FROM employe... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
3. A T. Rex, triceratops, and velociraptor stand in a triangle in a bit of a show down. The T. Rex is 12 m from the triceratops. The raptor is 20 m from triceratops. The triceratops has calculated...
-
From The American Scholar we have the following quote: In the degenerate state, when the victim of society, he [the scholar] tends to become a mere thinker, or, still worse, the parrot of other men's...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
2. Evaluate the following definite integrals (a) (2x - 6x) dx /6 (b) 16 cos 3t + 2 sin 3t dt x+1 2 da
-
Non-glare Glass. When viewing a piece of art that is behind glass, one often is affected by the light that is reflected off the front of the glass (called glare), which can make it difficult to see...
-
A truss that is pinned at one end and on rollers at the other will be statically determinate if it satisfies the following equation: 0 = 2j - m - 3 where j is the number of joints and m is the number...
-
What is a split-ballot technique and what is it used for?
-
Condensed financial data of Ziebert Company are shown below. Additional information:1. New plant assets costing $146,000 were purchased for cash during the year.2. Investments were sold at cost.3....
-
What is the output of the following C code? 1 int x=6; 2 int *q=&x, &qq=*x; 3 4 5 (q)=2; (*qq)+-3; int y-(*qq)*((*q)-2); printf("%d",y);
-
Understanding the relationship between business and society and the ways in which business and society are part of an interactive system.
-
The functionalist model/paradigm stressed the effect of media message and the process of message transmission. Taking from the perspective of the critical paradigm, why the functionalist paradigm was...
-
The Bonding Company prepares accrual basis financial statements every June 30 and December 31. On 1/1/2001 the company issued bonds to the public. The bonds are due at the end of 20 years, on...
-
The Jablonski family has a monthly income of $6,500. They're applying for an FHA loan with monthly payments of $2,200. They have student loan payments of $300 per month and a minimum payment of $20...
-
In addition to knowing that the visa became current on May 1, 2023, you find out the following information: The petition was filed on August 2, 2010. It was approved on March 15, 2012. Liam was born...
-
Content AreaOmega Inc. is expecting a reduction of $25,000 in fixed costs of $725,000. What will be the change in break-even sales (in units) if selling price per unit is $50 and the unit variable...
-
Are "unconditional promises to give" required to be recognized as liabilities? 18. What is the recognition threshold for recording a gain contingency? In an internal use software project, what are...
-
The distribution of a stock dividend ________. a) decreases both assets and liabilities b) decreases assets and increase liabilities c) effects only stockholders equity accounts d) increases both...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Design a database to...
-
Write the SQL command to revoke user Stetsons privilege.
-
The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required. 1. Using the types of entities found in the Solmaris...
-
Test for misspecification using RESET.
-
a. Show that the mean-squared forecast error \(E\left[\left(\hat{y}_{T+1}-y_{T+1} ight)^{2} \mid I_{T} ight]\) for a forecast \(\hat{y}_{T+1}\), that depends only on past information \(I_{T}\), can...
-
Consider the AR(1) model \(y_{t}=\delta+\theta y_{t-1}+e_{t}\) where \(|\theta|)=0\) and \(\operatorname{var}\left(e_{t} \mid I_{t-1} ight)=\sigma^{2}\). Let \(\bar{y}_{-1}=\sum_{t=2}^{T} y_{t}...
Study smarter with the SolutionInn App