Informatics Practices
Consider following tables to answer below question :
Salesman (salesman_id, name, city, commission ) and
Customer (customer_id, cust_name, city, grade, salesman_id )
Write an SQL query to list all the salesmen who have customers with grade 200 from city 'JAMMU'.
SQL Joins & Grouping
1 Like
Answer
SELECT s.name
FROM Salesman s, Customer c
WHERE s.salesman_id = c.salesman_id AND (c.grade = 200 AND c.city = 'JAMMU');
Answered By
2 Likes
Related Questions
Consider following tables to answer below question :
Salesman (salesman_id, name, city, commission ) and Customer (customer_id, cust_name, city, grade, salesman_id )Write an SQL query to list all the salesmen who do not have customers in 'DELHI' and 'JAMMU'.
Consider following tables to answer below question :
Salesman (salesman_id, name, city, commission ) and Customer (customer_id, cust_name, city, grade, salesman_id )Write an SQL query to list all the salesmen who have customers with grade 200 or higher.
Consider following tables to answer questions 15-20 :
Salesman (salesman_id, name, city, commission ) and Customer (customer_id, cust_name, city, grade, salesman_id )Write an SQL query to list all the customers whose salesmen have earned a commission of at least 15%.
Write a SQL query to display all the divnos from both the tables.
Table : Member
EmpId Name Pay Divno 1001 Shankhya 34000 10 1003 Ridhima 32000 50 1002 Sunish 45000 20 Table : Division
Divno Divname Location 10 Media TF02 20 Dance FF02 30 Production SF01