1.List the full name of members who are not from the state of IN nor IL. 2.List

Question

1.List the full name of members who are not from the state of IN nor IL.
2.List the full name of each member and the full names of the employees’ who ever assisted that member on a transaction.
3.List the full name and full address of the member who has the highest credit limit.
4.List the full name, title, and department of the employee who handled online transactions.
5.List the member ID, full name, and credit limit of each customer whose credit limit is greater than the average credit limit of all members.
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

Explanation / Answer

1. SELECT MEMBERS.MFIRST, MEMBERS.MLAST FROM MEMBERS WHERE MEMBERS.STATE <> 'IN' OR MEMBERS.STATE <> 'IL'

2. SELECT MEMBERS.MFIRST, MEMBERS.MLAST FROM MEMBERS, EMPLOYEES.EFIRST, EMPLOYEES.ELAST FROM MEMBERS, EMPLOYEES, TRANSACTIONS WHERE MEMBERS.MEMBERID = TRANSACTIONS.MEMBERID AND TRANSACTIONS.EMPLOYEEID = EMPLOYEE.EMPLOYEEID

3. SELECT MEMBERS.MFIRST, MEMBERS.MLAST FROM MEMBERS WHERE MEMBERS.STREET, MEMBERS.CITY, MEMBERS.STATE, MEMBERS,ZIPCODE WHERE MEMBERS.CREDITLIMIT = MAX(MEMBERS.CREDITLIMIT)

4. iNFORMATION MISSING

5. SELECT MEMBERS.MEMBERSID, MEMBERS.MFIRST, MEMBERS.MLAST, MEMBERS.CREDITLIMIT FROM MEMBERS WHERE MEMBERS.CREDITLIMIT>AVG(MEMBERS.CREDITLIMIT)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.