Question: 13. Write a SQL query to find cities in which suppliers, customers, departments are located at the same time. (5 points) 14. Write a

13. Write a SQL query to find cities in which suppliers, customers, departments are located at the same time. (5 points) 14. Write a SQL query to find customers who received discount of more than 50 percent from the company. Return Customer First name, discount. (5 points) 15. Write a SQL query to retrieve employees and projects they are working on. (5 points) 16. Write a SQL query to display the names of employees whose department is located in the city of Helsinki. (5 points)

Step by Step Solution

★★★★★

3.44 Rating (147 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

13 Find cities in which suppliers customers and departments are located at the same time SELECT City ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

A car manufacturer conducts a survey to see how appealing its new model is to its existing customer base. It selects current customers at random, and gives them a new vehicle with two different car...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Bike World, Inc., wholesales a line of custom road bikes. Bike World's inventory, as of November 30, 2016, consisted of 22 mountain bikes costing $1,650 each. Bike World's trial balance as of...

The voltage and current at the input of a circuit are given by the expressions v(t) = 170 cos (wt + 30o)V, i(t) = 5 cos (wt + 45o)A. determine the average power absorbed by the circuit.

9. What is the test for managerial employees? What is the test for confidential employees?

describe the distinct effects of positive emotions;

During its manufacture, plate glass at 600C is cooled by passing air over its surface such that the convection heat transfer coefficient is h = 5 W/m2 K. To prevent cracking, it is known that the...

Find molar volume of n-propane (look up the critical values and accentric factor) at a) 450K and 2 bars and b) 350K and 3.396 bar. Use the following methods: 1) ideal gas state 2) generalized...

At age 25, someone sets up an IRA (individual retirement account) with an APR of 5%. At the end of each month he deposits $60 in the account. How much will the IRA contain when he retires at age 65?...

The Soma Inn is trying to determine its break-even point. The inn has 75 rooms that arerented at $60 anight. Operating costs are as follows $9.700 per month Salaries Utilities 2.700 per month...

For this discussion, will reference your course textbook in addition to your results from the Self-Assessment: Which Benefits Are Important to You? Describe the benefits package at your organization...

1. Financial institutions use stress tests of CCR as a credit risk which allows them to advance beyond simple stresses of current exposure. These tests permit the accumulation of losses due to loan...

Consider a simple 8-bit configuration register, where each bit sets the configuration of 8 different pins ([7...0]), where setting a bit to 0 means configuring input and setting 1 means output: char...

Think about French and Raven's model and discuss how you have used power in the past (at work, school, in relationships, or with your family, etc.). Think about a specific example. How did it feel to...

Duffing's equation, x+dxx+x =ycos(wt), exhibits chaotic behavior for its parameters in certain ranges. Simulate this equation for (8, y, w) = (0.05, 0.4, 1.3) and plot the phase portrait (i.e., plot...

C. Data for the Australian and U.S. spot rate curves is provided here: Maturity Australian Spot Rates U.S. Spot Rates 6-Months 2.31% 0.23% 1-Year 2.03% 0.37% 18-Months 1.98% 0.54% 2-Years 2.03% 0.70%...

Provide a draft/outline of legal research involving an indigenous Canadian woman charged with assault causing bodily harm under (Sec 267b) of the Criminal Code, where the crown wants a 12-month jail...

Judds Reproductions makes reproductions of antique tables and chairs and sells them through three sales outlets. The product line consists of two styles of chairs, two styles of tables, and three...

What four categories of processes are useful in developing the process perspective measures for a Balanced Scorecard?

One of the most widely accepted and longest held beliefs is the controllability principle, which says that organization units and people should be held accountable only for things that they can...

The United States Postal Service (USPS) has a government monopoly on home mail delivery, but several private companies, such as FedEx, UPS, and DHL, compete with the USPS for other types of delivery...

Figure 14P-1 presents the demand curve, marginal revenue, and marginal costs facing a monopolist producer. a. What is the profit-maximizing level of output? b. What price will the monopolist charge...

Use Figure 14P-3 to answer the following questions. a. Under monopoly pricing, are profits positive, negative, or zero? b. If government regulates average total cost pricing (P = ATC), are profits...