Question: In the following exercises, you will use the data in the BITS database. In each step, use SQL to obtain the desired results. Note: use

In the following exercises, you will use the data in the BITS database. In each step, use SQL to obtain the desired results. Note: use screenshots to present your answer if applicable.
1. List the number and name of all clients.
2. Show the complete Tasks table.
3. Count the number of clients represented by consultant 22.
4. List the number and name of all clients that are represented by consultant 22 and that have credit limits of$10,000.
5. List the number and name of all clients that are represented by consultant 22 or that have credit limits of $10,000.
6. For each work order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order.
7. List the number and name of all clients represented by Sarah Allen.
8. How many clients have a credit limit of $10,000?
9. Find the total of the balances for all clients represented by consultant 35.
10. List the name and remaining credit (CreditLimit-Balance) for each client.
11. List all columns and all rows in the Client table. Sort the results by name.12. List all columns and all rows in the Tasks table. Sort the results by price within category.
13. For each consultant, list the consultant last name, the average balance of the consultant's clients, and the number of clients assigned to the consultant. Group the records by consultant name, and order the records by consultant name.
14. Create a new table named Sept21 to contain the columns OrderNum, TaskID, Description, ScheduledDate, QuotedPrice for all rows on which the ScheduledDate is 9/21/2018.
15. In the Sept21 table, change the description of TaskID PI54 to "Misc. Printing."
In the following exercises, you will use the data

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

Q:

An article in Quality Progress (May 2011, pp. 4248) describes the use of factorial experiments to improve a silver powder production process. This product is used in conductive pastes to manufacture...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database...

Q:

In the following exercises, you will use the data in the BITS Corporation database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the BITS Corporation database...

Q:

In the following exercises, you will use the data in the BITS Corporation database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the BITS Corporation database...

Q:

Please help me this assignment, thank you! BITS Corporation Exercises: Relational Algebra In the following exercises, you will use the data in the BITS Corporation database shown in Figure 2-1. In...

Q:

Write to R. R Bronson, requesting a reasonable delay in your consideration of his job offer.

Q:

1. Macys, Inc., through its subsidiaries, operates approximately 800 department stores in the United States. Its retail stores sell a range of merchandise, including apparel, home furnishings, and...

Q:

A B C D E F G H I J K Firms HL and LL are identical except for their financial leverage ratios and the interest rates they pay on debt. Each has $ 3 3 million in invested capital, has $ 7 million of...

Q:

If the demand for loanable funds increases, what will happen to real interest rates and the economic growth? Real Interest Rates / Economic Growth a. Increase / Increase b. Increase / Decrease c....