Question: Subject: Database Systems Can you please answer questions 4, 5, and 6? I will give a thumb up. Consider the following tables (Salesman and Customer,

Subject: Database Systems

Can you please answer questions 4, 5, and 6? I will give a thumb up.

Subject: Database Systems Can you please answer questions 4, 5, and 6? I will give a thumb up. Consider the following tables (Salesman and

Consider the following tables (Salesman and Customer, respectively). 4) Assume that the salesman's hourly salary is calculated by multiplying the salesman's commission with 100. create a view of salesmen showing their corresponding salaries. Return customer name, commission and salary.-.-9 5) Write an SQL query to find the difference between the salespeople's salaries and the average salary.--9 6) Write an SQL query to show all people involved in this business and their role (customer or salesman). Return ID, name, and role.-.9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

The government of the province of Laputa (in the Republic of Ivarrona) has installed Telemedicine Kiosks in many urban and rural locations in the country. These Kiosks have medical devices that can...

Please answer questions in the first picture. The article is in the following pictures. Read above article of a recent news event. a. Why does the board of directors usually authorize the company to...

I'm in serious need of help in my accounting class (acc205) . I'm falling behind and I need help with this weeks assignment. for week three for the may-june month . can someone please help me ....

Hi tutors, can anyone help me work on the below assignment thanks. Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By...

Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By 2010, discussions began about whether "cash hoarding" by firms was...

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

The incomes of all families in a particular suburb can be represented by a continuous random variable. It is known that the median income for all families in this suburb is $60,000 and that 40% of...

Zeta, Inc., owns Juliet Corp. The two companies individual balance sheets follow: Requirements 1. Prepare a consolidated balance sheet of Zeta, Inc. It is sufficient to complete the consolidation...

Question 3 of 5 . All of the following taxpayers are using the single filing status for 2 0 2 4 , had a 2 0 2 3 adjusted gross income of less than $ 1 1 0 , 0 0 0 , and have estimated withholding and...

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

1. Who Moved My Cheese? is the all-time best-selling book in Amazon.coms history and is printed in 42 languages. Analyze why organizations around the world would buy millions of these books for their...

1. The first Stew Leonards retail grocery was established in 1969. Do you think the culture established and nurtured at this successful firm could be adopted by other retail grocery stores? Explain...

1. In the bright light of hindsight, most of us would probably say we would blow the whistle on these instances had we been a witness to them, especially because there was so much money involved. But...