Question

Using the following tables write a sql command:

List the full name and the total number of transactions handled by the full time

employee. Rank your results in descending order on the total number of transactions.

Table: MEMBERS Column Data Type Length Precision Scale Nullable MEMBERID NUMBER 4 0 No MFIRST VARCHAR2 25 No MLAST VARCHAR2 25 No STREET VARCHAR2 64 No CITY VARCHAR2 25 . No STATE VARCHAR2 2 . No ZIPCODE NUMBER 0 No CREDITLIMIT NUMBER 7 2 No GENDER VARCHAR2 - No

Answer 1

select concat(e.EFIRST," ",e.ELAST)as EMPLOYEENAME,e.EMPLOYEEID, Count(t.TRANSCATIONID) as TOTAL TRANSACTIONS
from EMPLOYEES e
join TRANSACTIONS t ON t.EMPLOYEEID = e.EMPLOYEEID
where e.ETYPE = "FULL-TIME"
order by Count(t.TRANSCATIONID) desc;

/*The above query will give us the details about the Employee name, Employee ID and total no of transactions made by the FUll time employee. It will be ordered in Descending order*/

Sample output:

EMPLOYEENAME	EMPLOYEEID	TOTAL TRANSACTIONS
Ahmad Raja	2341	10
Kelly James	1324	5
Ben Stokes	2345	2