Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List the number and name of all clients. List the complete Tasks table. List the number and name of all clients represented by consultant 19.
- List the number and name of all clients.
- List the complete Tasks table.
- List the number and name of all clients represented by consultant 19.
- List the number and name of all clients that are represented by consultant 19 and that have a credit limit of $10,000.
- List the number and name of all clients that are represented by consultant 19 or that have a credit limit of $10,000.
- For each order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order.
- List the number and name of all clients represented by Patrick Jordan.
- How many clients have a credit limit of $5,000?
- Find the total of the balances for all clients represented by consultant 22.
- List the ClientNum, CreditLimit, and Balance, and list the available credit (CreditLimit - Balance) for each client represented by consultant 19.
- List all columns and all records in the Consultant table. Sort the results by last name.
- List all columns and all records in the Tasks table. Sort the results by price within category.
- List the category and price for all orders. Group the results by category.
- Create a new table named ScheduledClients to contain clients name, the scheduled date of service, task ID, description of the service, and the quoted price.
- In the ScheduledClients table, change the description of item VR39 to Virus detection and removal. Adjust the column widths as necessary.
- In the ScheduledClients table, delete every row on which the price is greater than $500.
- There are two ways to create the query in Exercise 11. What are they? Which one did you use?
- An employee of BITS Corporation created the query shown in Figure 2-48. She wants to list the client number and the task IDs associated with each order. Will the query results be correct? If so, list other fields that would be useful. If not, how should she modify the query to achieve this result?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started