Since i dont see anyone helping, i will try. mero sql ni teti ramro chaina :)

First off, I learned sql on my own 8 yrs back and never used it so my memory is not fresh.
Second, if you cannot do this simple problem then forget about graduating with good gpa, and don't blame it on USA when u don't get a job after graduating. Alikati ta afai padhnu payo ni som.

Select fname, lname
From employee
Where salary>( (select min(salary) from employee)+10000);

2. Select fname, lname
From employee
Where dno=(select dno from employee where salary=(select max(salary) from employee));

Stiffler's query is ok for 2 for the given data. But if there are multiple employees (whether in the same department or different departments) that earn the same salary that happen to be the highest for the company, then the query will return an error.

Following query should handle that situation.

Select fname, lname
From employee
Where dno in (select distinct dno from employee where salary=(select max(salary) from employee));

Or you could use this.

Select e.fname, e.lname
From employee e inner join

(select distinct dno from employee

   where salary=(select max(salary) from employee)

) m
on e.dno = m.dno

 

 

 

Napadheko hoina bro...

Ma aafaile try gari sake ani answer lekhe tara ali sure bhayena...

Feri prof lastai kadha question sodhcha exam ma...ani grade dherai lyaune bhanekai assignment bata ho..

So make sure gareko..

Anyway Thanks hai duitai sathi haru!

 

Not a problem. I am not not criticizing you, merely cautioning u that u need to master these things and go beyond the homeworks if u want to be hired after graduation. Agree with yotabhayenanisom.