Create table and execute following Query. Please send me your query (code) and output of your...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create table and execute following Query. Please send me your query (code) and output of your query. Sal DOB 9/17/1981 5000 7839 7698 Manager 7839 5/1/1981 2850 7782 Manager 7839 6/9/1981 2450 7886 Janes Manager 7839 4/2/1981 2975 2/20/1981 1250 2/8/1981 1630 3/9/1981 1500 7654 Martin Salesman 7698 7499 Allen Salesman 7698 7844 James Clerk 7698 7900 Turner Clerk 7699 7521 James Salesman 7698 3/11/1981 1250 1902 Ward Analyst 7566 3/12/1981 3/10/1981 950 300 7369 500 7888 Ford Clerk 7902 4/1/1981 Scott Analyst 7566 4/2/1981 Adams Clerk 3000 7876 7788 4/3/1981 1100 EMP NO Ename King Bike Clerk Job President MGR Comm Deptna 10 30 10 30 30 20 20 20 10 20 10 30 10 400 500 1). Find total how many rows are there? Using SQL command 2). Display all data in ascending order by salary 3). Display sal and deptno from emp table group by deptno 4). Display dept no, sum of sal and count of ename by group by dept no (in one sql statement) 5). Display common ename, Comm, sal, deptno, loc and com_name from emp and company detail tables and group by loc and order by ename Create table and execute following Query. Please send me your query (code) and output of your query. Sal DOB 9/17/1981 5000 7839 7698 Manager 7839 5/1/1981 2850 7782 Manager 7839 6/9/1981 2450 7886 Janes Manager 7839 4/2/1981 2975 2/20/1981 1250 2/8/1981 1630 3/9/1981 1500 7654 Martin Salesman 7698 7499 Allen Salesman 7698 7844 James Clerk 7698 7900 Turner Clerk 7699 7521 James Salesman 7698 3/11/1981 1250 1902 Ward Analyst 7566 3/12/1981 3/10/1981 950 300 7369 500 7888 Ford Clerk 7902 4/1/1981 Scott Analyst 7566 4/2/1981 Adams Clerk 3000 7876 7788 4/3/1981 1100 EMP NO Ename King Bike Clerk Job President MGR Comm Deptna 10 30 10 30 30 20 20 20 10 20 10 30 10 400 500 1). Find total how many rows are there? Using SQL command 2). Display all data in ascending order by salary 3). Display sal and deptno from emp table group by deptno 4). Display dept no, sum of sal and count of ename by group by dept no (in one sql statement) 5). Display common ename, Comm, sal, deptno, loc and com_name from emp and company detail tables and group by loc and order by ename
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
1 - What is beta? 2 - Stock ABC has a beta of 1.25 and Stock XYZ has a beta of 0.55. Which stock would you buy if you knew the stock market was going to drop by 20% over the next month? Also, briefly...
-
The next Java code needs to be converted from static to dynamic (just addd changes in same code): import java.util.Scanner; class MyIntStaticCircularQueue { int capacity = 2; int queue[] = new...
-
Simmel argued a century ago that the pace of life had quickened inexorably: the populace of the metropolis was constantly searching out new entertainments and distractions, but satisfaction was only...
-
Mark Cotteleer owns a company that manufactures sailboats, Actual demand for Marks sailboats during each season in 2006 through 2009 was as follows: Mark has forecasted that annual demand for his...
-
A flat-belt drive is to consist of two 4-ft-diameter cast-iron pulleys spaced 16 ft apart. Select a belt type to transmit 60 hp at a pulley speed of 380 rev/min. Use a service factor of 1.1 and a...
-
Assume the Federal Interstate Commission began the fiscal year with the following account balances: 1. Congress passed a spending bill providing $16,000,000 to fund the agency's operations for the...
-
Medrano Ltd is a furniture manufacturer. The company is looking at three alternative specialised machines to replace its existing production line. Data for each of the machines are as follows. The...
-
Mullins Distribution markets CDs of numerous performing artists. At the beginning of March, Mullins had in beginning inventory 2,500 CDs with a unit cost of $7. During March, Mullins made the...
-
3) A bicycle tire pump has a piston with area 0.40 in 2 . If a person exerts a force of 15 lb on the piston while inflating a tire, what pressure does this produce on the air in the pump? 4) A large...
-
A stepped shaft ACB having solid circular cross sections with two different diameters is held against rotation at the ends (see figure). If the allowable shear stress in the shaft is 6000 psi, what...
-
6. [-/1 Points] DETAILS Find the derivative of the function. 3 2 g(x) = + +9x x g'(x) = Need Help? Read It 7. [-/4 Points] DETAILS Consider the following. y = x - 4x +6 Evaluate y when x = 1. y(1) =...
-
QUESTION 3 a) Differentiate between the following concepts: increasing return to scale, decreasing return to scale and constant return to scale. [6 Marks] b) Characterise the short-run profit...
-
Explain how the two companies have continued to evolve their ERP systems over time, what lessons can be learned from Amazon and Apple's ERP integration experiences, and how can these lessons be...
-
Indifference curves analysis has revolutionised the way modern economists analyse consumer behaviour. a) With the aid of a relevant diagram explain what you understand by indifference curves in...
-
An appraiser inspected a two story home 25' x 50', with a full unfinished basement and an attached single story garage on slab 24' x 36'. What is this building's GLA?
-
A formula for calculating the magnitude of an earthquake is M E that uses the common = 323 log (5) (base 10) logarithm. This is called the Moment Magnitude Scale (MMS), an alternative to the more...
-
In appropriate situations, the IRS may assert: a. That the Corporation be disregarded as a sham or a nominee b. That income reported by the Corporation belongs to the shareholders personal Form c....
-
Hotel Majestic is interested in estimating fixed and variable costs so that the company can make more accurate projections of costs and profit. The hotel is in a resort area that is particularly busy...
-
Jim Watanabe, project director for the No Customer Escapes customer loyalty system for Petrie Electronics, walked into the conference room. Sally Fukuyama, from marketing, and Sanjay Agarwal, from...
-
Jim Watanabe was in his new car, driving down I-5, on his way to work. He dreaded the phone call he knew he was going to have to make. The original go-live date for a pilot implementation of Petrie...
-
There is a strong movement toward wireless mobile computing using thin-client technology. Go to the Web and visit some of the major computer vendors that are producing thin-client products such as...
-
You must filter $1000 \mathrm{lb}_{\mathrm{m}} / \mathrm{min}$ of an aqueous slurry containing $40 %$ solids by weight using a rotary drum filter with a diameter of $4 \mathrm{~m}$ and a length of $4...
-
Calculate the flow rate of water (in gpm) required to fluidize a bed of 1/16 in. diameter lead shot $(S G=11.3)$. The bed is $1 \mathrm{ft}$ in diameter, $1 \mathrm{ft}$ deep, and has a porosity of...
-
A coal gasification reactor operates with particles of $500 \mu \mathrm{m}$ diameter and a density of $1.4 \mathrm{~g} / \mathrm{cm}^{3}$. The gas may be assumed to have properties of air at...
Study smarter with the SolutionInn App