Write a query to list the region_id and the first three letters of all countries within...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write a query to list the region_id and the first three letters of all countries within region 2. Show the output in alphabetical order and display the results in the format shown below. country_code region_id CAN UNI 2 2 Write a query to list all departments and the names of their managers. Display the data in the format shown below. For departments that have no manager show 'No Manager!. Sort the output in order of the manager's salary (highest to lowest). department_id department_name Manager 90 20 110 80 60 50 10 190 Executive Marketing Accounting Sales IT Shipping Administration Contracting KING, Steven HARTSTEIN, Michael HIGGINS, Shelley ZLOTKEY, Eleni HUNOLD, Alexander MOURGOS, Kevin WHALEN, Jennifer No Manager Write a query which displays the full name and department id of employees who work in the same department as anyone whose last name starts with 'M' Do not display anyone whose last name starts with 'M' Employee Trenna Rajs Curtis Davies Peter Vargas department_id 50 50 50 Write a query to find the total salaries of all the employees in each department. Employees that are not in a department should appear as being in the department "None" Order the results alphabetically by department name Do not display any departments that have a total salary of 30000 or greater department_id department_name total_salary 70 10 40 20 None 50 30 (7 rows affected) Accounting Administration IT Marketing None Sales Shipping $20000.00 $4400.00 200.00 $16500.00 $7000.00 $29500.00 $17700.00 Write a query to list the region_id and the first three letters of all countries within region 2. Show the output in alphabetical order and display the results in the format shown below. country_code region_id CAN UNI 2 2 Write a query to list all departments and the names of their managers. Display the data in the format shown below. For departments that have no manager show 'No Manager!. Sort the output in order of the manager's salary (highest to lowest). department_id department_name Manager 90 20 110 80 60 50 10 190 Executive Marketing Accounting Sales IT Shipping Administration Contracting KING, Steven HARTSTEIN, Michael HIGGINS, Shelley ZLOTKEY, Eleni HUNOLD, Alexander MOURGOS, Kevin WHALEN, Jennifer No Manager Write a query which displays the full name and department id of employees who work in the same department as anyone whose last name starts with 'M' Do not display anyone whose last name starts with 'M' Employee Trenna Rajs Curtis Davies Peter Vargas department_id 50 50 50 Write a query to find the total salaries of all the employees in each department. Employees that are not in a department should appear as being in the department "None" Order the results alphabetically by department name Do not display any departments that have a total salary of 30000 or greater department_id department_name total_salary 70 10 40 20 None 50 30 (7 rows affected) Accounting Administration IT Marketing None Sales Shipping $20000.00 $4400.00 200.00 $16500.00 $7000.00 $29500.00 $17700.00
Expert Answer:
Answer rating: 100% (QA)
1 2 ANSWER 3 4 5 6 7 List the regionid and the first three letters of all countries within region 2 ... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Either by hand, or using computer software, make a box-and-whisker plot and find the interquartile range of the data. Lower and upper fences not required. 23 2 5 14 25 36 27 42 12 8 7 23 29 26 28 11...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
Could you elucidate the process of normalizing a database schema, delineating the various normal forms such as 1NF, 2NF, and 3NF, and elucidating their significance in optimizing database design ?
-
Using the information for Sarot, Inc., in SE 4 and SE 5, compute the current ratio, quick ratio, receivable turnover, days sales uncollected, inventory turnover, days inventory on hand, payables...
-
Air is contained in the insulated cylinder shown in Fig. P6.70. At this point the air is at 20 lbf/in 2, 80 F, and the cylinder volume is 0.5 ft3. The piston cross-sectional area is 0.5 ft2, and the...
-
(a) The Sun is a nearly perfect blackbody emitter (e 1) with a temperature of 5500 K and a radius of 7 10 8 m. Determine the radiative power that the Earth receives from the Sun. The distance between...
-
What are the final two steps a researcher should do after presenting the research findings to the decision makers?
-
On December 31, 2010, Hawthorne Corporation issued for $155,989, five-year bonds with a face amount of $150,000 and a stated (or coupon) rate of 9 percent. The bonds pay interest annually and have an...
-
A firm has 10,000,000 shares of common stock outstanding, each with a market price of $15.00 per share. It has 80,000 bonds outstanding, each selling for $1020. The bonds mature in 15 years, have a...
-
You team is using potentiometers to capture the movement of a human subject's arm. You goal is to use the potentiometer readings (which measure angles) to track the position of the subject's hand....
-
Of the risks Starbucks Corporation discloses, you must identify at least one risk at Starbucks store level and connect it to a financial statement, explaining its adverse financial statement outcomes...
-
Describe the attributes of an attractive industry for a new venture.
-
Explain the tax status of child support payments.
-
In what sense do these market value ratios reflect investors opinions about a stocks risk and expected future growth?
-
What is a business plan? What are the advantages of preparing a business plan for a new venture? Explain your answer.
-
Generally, what is "at risk"?
-
What is size of void in C++? Select one: 0 O a. 0 Bytes b. 4 Bytes c. 8 Bytes d. 1 Byte e. 2 Bytes a
-
a) Show that (a, b) := {{a}, {b}} does not satisfy the ordered pair axiom. b) Determine whether each of the following statements is true or false. (Give a reason in each case): (i) {a, b} C (a, b)....
-
Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint, the third column has a CHECK...
-
Oracle 11g automatically creates an index for which type of constraints? a. NOT NULL b. PRIMARY KEY c. FOREIGN KEY d. UNIQUE KEY e. Mone of the above f. Only a and b g. Only b and d
-
Whats the difference between a key-preserved and a non-key-preserved table?
-
Identify each of the following as a consumer product or a business product, or classify it as both: a. frozen yogurt b. iPad c. gasoline d. boat trailer e. hand sanitizer f. Post-its
-
What are the steps in developing a marketing strategy?
-
What is the difference between primary data and secondary data?
Study smarter with the SolutionInn App