Question

no spam answer,else reported
SQL and dbms​

Answer 1

Answer:

Select Code, Name From Salesperson

Where Salary > 70000

Select * From Salesperson Order by Salary

Select I.ItemType,  Count(s.etcode) from Item i inner join Salesperson s on i.itcode=s.etcode

Group by i.itemtype, i.itcode

Select s.Name, i.ItemType From Salesperson s inner join Item i on s.EtCode=i.ItCode

Max(salary) = 80000

Count = 5

1003   Tenzin  80000  12

3400000