You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

Michael Reber 8c9a19ec97 Adding SQL query language		4 years ago
..
1. Write a query to create a view for those salesmen belongs to the city New York.sql	Adding SQL query language	4 years ago
2. Write a query to create a view for all salesmen with columns salesman_id, name and city.sql	Adding SQL query language	4 years ago
3. Write a query to find the salesmen of the city New York who achieved the commission more than 13%.sql	Adding SQL query language	4 years ago
4.Write a query to create a view to getting a count of how many customers we have at each level of a grade.sql	Adding SQL query language	4 years ago
5. Write a query to create a view to keeping track the number of customers ordering, number of salesmen attached.sql	Adding SQL query language	4 years ago
6. Write a query to create a view that shows for each order the salesman and customer by name.sql	Adding SQL query language	4 years ago
7. Write a query to create a view that finds the salesman who has the customer with the highest order of a day.sql	Adding SQL query language	4 years ago
8. Write a query to create a view that finds the salesman who has the customer with the highest order at least 3 times on a day.sql	Adding SQL query language	4 years ago
9. Write a query to create a view that shows all of the customers who have the highest grade.sql	Adding SQL query language	4 years ago
10. Write a query to create a view that shows the number of the salesman in each city.sql	Adding SQL query language	4 years ago
11. Write a query to create a view that shows the average and total orders for each salesman after his or her name. (Assume all names are unique).sql	Adding SQL query language	4 years ago
11. Write a query to create a view that shows the average and total orders for each salesman after his or her name.sql	Adding SQL query language	4 years ago
12. Write a query to create a view that shows each salesman with more than one customers.sql	Adding SQL query language	4 years ago
13. Write a query to create a view that shows all matches of customers with salesman.sql	Adding SQL query language	4 years ago
14. Write a query to create a view that shows the number of orders in each day.sql	Adding SQL query language	4 years ago
15. Write a query to create a view that finds the salesmen who issued orders on October 10th, 2012.sql	Adding SQL query language	4 years ago
16. Write a query to create a view that find the salesmen who issued orders on either August 17th, 2012 or October 10th, 2012.sql	Adding SQL query language	4 years ago