In each step, use SQL to obtain the desired results. You can use a DBMS to
complete the exercises using a computer, or you can simply write the SQL
command to complete each step. Check with your instructor if you are
uncertain about which approach to take. List the number and name of all
clients. List the complete Tasks table. List the number and name of every
client represented by consultant 22. List the number and name of all clients
that are represented by consultant 22 and that have credit limits of $10,000.
List the number and name of all clients that are represented by consultant
22 or that have credit limits of $10,000. 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. List the number and name of all clients
represented by Sarah Allen. How many clients have a credit limit of
$10,000? Find the total of the balances for all clients represented by
consultant 35. List the name and remaining credit (CreditLimit-Balance) for
each client. List all columns and all rows in the Client table. Sort the results
by name. List all columns and all rows in the Tasks table. Sort the results by
price within category. 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. Create a new table named Sept21