List the order number & date of all orders in the month of October.

data mining

Description

 

Utilizing TAL DISTRIBUTORS complete the following:

1.      List the order number & date of all orders in the month of October.

2.      Combine the Rep’s first name and last name into one column with a space between the first name and the last name and order the records by last name.

3.      Show the first three customers with the highest balance. List the name & balance

4.      Find the customer with the highest balance (use MAX function)

5.      Find the rep with the lowest commission. (use the MIN function)

 

Healthcare Synthetic Claims Database – 2

1) Find the number of claims in the carrier file for the year 2010 by each beneficiary.

2) How many patients were prescribed a 90-day supply of medication?

3) What was the maximum total amount of a prescription paid?

4) Find the patients under subsequent hospital care.

 


Related Questions in data mining category