26. List all customers serviced by salesman with commission above 12%.
SELECT c.cname, s.sname
FROM customer c
JOIN salesman s ON c.snum = s.snum
WHERE s.commission > 12;
Output:
| cname | sname |
|---|---|
| laxit | niraj |
| govind | niraj |
| pratik | rajesh |
SELECT c.cname, s.sname
FROM customer c
JOIN salesman s ON c.snum = s.snum
WHERE s.commission > 12;
| cname | sname |
|---|---|
| laxit | niraj |
| govind | niraj |
| pratik | rajesh |