SQL & PL/SQL

Hi All,

I need help with the below. Kindly give it a shot. Thanks a lot

create Customer_cars

(custid  number

,car varchar2(10)

);

insert into customer_cars values ( 1,'LEXUS');

insert into customer_cars values ( 1,'Toyota');

insert into customer_cars values ( 2,'LEXUS');

insert into customer_cars values (3,'MERC');

insert into customer_cars values (4,'LEXUS');

insert into customer_cars values (5,'BMW);

insert into customer_cars values ( 6,'LEXUS');

Table One : Customer_cars

Table Two

create Customer_Advisors

(custid  number

,Advisor varchar2(10)

Account varchar(10)

);

insert into customer_Advisors values ( 1,'Rick’, ‘abc’);

insert into customer_ Advisors values ( 1,'Max',ggg);

insert into customer_ Advisors values ( 1,'Rick’,’hhh’);

insert into customer_ Advisors values (2,'Johny',’xxx’);

insert into customer_ Advisors values (2,''Johny,’yyy’);

insert into customer_ Advisors values (3, ‘Bob’,’cc’);

insert into customer_ Advisors values ( 3,'Jack', ‘qq’);

insert into customer_ Advisors values ( 4,'Amy', ‘zzz’);

insert into customer_ Advisors values ( 4,'Susan', ‘jj’);

Table Two (check if more than one unique Advisor for  Lexus Customers

Get all the Id’s of Customers that have Lexus Car from table One.

Then  check table two to see if those Id’s have more than one unique Advisor

If so then display all the CustomerIds along with their Advisors and accounts.

We don’t need to display customers with only one Advisor (ex  Empid 2)

Final Output:

Get all the Id’s of Customers that have Lexus Car from table One.

Then  check table two to see if those Id’s have more than one unique Advisor

If so then display all the CustomerIds along with their Advisors and accounts.

We don’t need to display customers with only one Advisor (ex  Empid 2)