CISC 1050 Professor Sokol
1. Display the Client number and name for all clients that are situated in Austin.
2. Display the Client number, name, address, and zip code of all clients whose zip code begins with 28
3. Display the entire record of the business analyst (from the Business Analyst table) whose initials are J.S.
4.
You are asked to display the Client record of Hendley County Hospital, yet you are unsure whether Hendley is spelled “Hendley” or “Hendlay”.
Design a query that retrieves
the record whether you spell the name correctly or not.
5. Display the Client names, amount paid, and current due of all clients whose amount paid is more than $500. but less than $10,000.
6. Display the Client number, name, and address of all clients to whom Camashaly Design has no debt.
7. Display the average amount of the Current Due per city (use the Client table).
8. Display all fields for all Client in the city of Burles or Buda.
9. Display the amount money that each business analyst has earned so far this year. (add salary YTD and incentive)
10.
Display the Last and First name of each business analyst and the
Client numbers and names that the business analyst services.
The list should be sorted
by the business analyst's last names.
11.
Display, for each business analyst, the total amount paid by all
of the clients that he services.
Sort by business analyst number.