Question: Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image). (10) For each consultant whose

  1. Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image).
    1. (10) For each consultant whose clients average balance is less than $4,000, list the consultant number, the number of clients assigned to the consultant, and the average balance of the consultants clients. Rename the count of the number of clients to NumOfClients and the average of the balances to AvgBalance. Order the groups by consultant number.

  1. (10) For every work order, list the order number, order date, client number, and client name. In addition, for each order line within the order, list the TaskID and description. Order the records by order number.

  1. (10) Show the consultants names and the total quoted price for all the orders made for each consultant.

I need help writing the SQL code for this two questions

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!

Q:

Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image). (10) Add a field named AllocatedTime to the Tasks table. The allocation is a...

Q:

Create tables as described with sample data, and then write SQL queries for the given problems. Note your confidence levels for each SQL query on a scale of [0, 10]. */ DROP TABLE Printer CASCADE...

Q:

Introduction: This assignment will use a database containing data about a university. You need to create all the tables/relations from the .txt files as attached. (You can use the psql command...

Q:

Create tables as described with sample data, and then write SQL queries for the given problems. */ DROP TABLE Printer CASCADE CONSTRAINTS; DROP TABLE Laptop CASCADE CONSTRAINTS; DROP TABLE PC CASCADE...

Q:

DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X...

Q:

I NEED the SQL commands ASAP. THANK YOU. Click to Add All Access Obje... 0 Search. Tables BE Customer A FEE Guide Customer X CustomerNum - # 101 + 102 # 103 + 104 # 105 + 106 # 107 + 108 + 109 BEE...

Q:

Please help answer 16 and 17 or 18 and 20 if you can. This is all the information I was given below. As per the instructions you cannot use JOIN statements or subqueries. Here are the other questions...

Q:

1. Based on the tables we used in SQL Exercise Part 3 (i.e., CEOs, Companies, Countries), write SQL queries to answer the following questions. Please include both your SQL query and result...

Q:

Consider the above given schema and write down following SQL queries. 1. Display the highest, lowest, sum and average salary of all employees. Label the columns Maximum, Minimum, Sum and Average...

Q:

write sql queries Project 1 Write SQL queries for the following from the database Waterlab. For queries 1, 2, and 4, you may optionally use the With clause. 1. For parameter 'Dissolved Ammonia',...

Q:

A 30-year mortgage has an annual interest rate of 7.18 percent and a loan amount of $180,000. What are the monthly mortgage payments?

Q:

The comparative balance sheet of Medalist Athletic Apparel Co. at December 31, 2006 and 2005 is as follows: Additional data obtained from the income statement and from an examination of the accounts...

Q:

EXERCISE 9-2. Writing Assignment Pauline Hsu is the manager of the office products division of Lomar Enterprises. In this position, her annual bonus is based on an appraisal of return on investment...

Q:

Your friend, Suzie Whitson, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzies product will target two groups: day care...

Q:

=+the type of IE employed? Or, stated from the other direction, which type of IE tends to be used under which strategy (international,

Q:

=+4 Which international business or cross-cultural competency is required by which type of international employee? For example, does every

Q:

=+multidomestic, global, transnational) or structure (subsidiary, joint venture, alliance, sub-contract) or managerial orientation (ethnocentric, regiocentric, geocentric)?