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 or higher.
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 display distinct salesman and their cities.
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 from city 'JAMMU'.
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%.