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 display all the orders from the orders table issued by the salesman 'Paul Adam'.sql Adding SQL query language 4 years ago
2. Write a query to display all the orders for the salesman who belongs to the city London.sql Adding SQL query language 4 years ago
3. Write a query to find all the orders issued against the salesman who works for customer whose id is 3007.sql Adding SQL query language 4 years ago
4. Write a query to display all the orders which values are greater than the average order value for 10th October 2012.sql Adding SQL query language 4 years ago
5. Write a query to find all orders attributed to a salesman in New york.sql Adding SQL query language 4 years ago
6. Write a query to display the commission of all the salesmen servicing customers in Paris.sql Adding SQL query language 4 years ago
7. Write a query to display all the customers whose id is 2001 bellow the salesman ID of Mc Lyon.sql Adding SQL query language 4 years ago
8. Write a query to counts the customers with grades above New York's average.sql Adding SQL query language 4 years ago
9. Write a query to display all customers with orders on October 5, 2012.sql Adding SQL query language 4 years ago
10. Write a query to display all the customers with orders issued on date 17th August, 2012.sql Adding SQL query language 4 years ago
11. Write a query to find the name and numbers of all salesmen who had more than one customer.sql Adding SQL query language 4 years ago
12. Write a query to find all orders with order amounts which are above-average amounts for their customers.sql Adding SQL query language 4 years ago
13. Write a queries to find all orders with order amounts which are on or above-average amounts for their customers.sql Adding SQL query language 4 years ago
15. Write a query to extract the data from the customer table if and only if one or more of the customers in the customer table are located in London.sql Adding SQL query language 4 years ago
16. Write a query to find the salesmen who have multiple customers.sql Adding SQL query language 4 years ago
17. Write a query to find all the salesmen who worked for only one customer.sql Adding SQL query language 4 years ago
18. Write a query that extract the rows of all salesmen who have customers with more than one orders.sql Adding SQL query language 4 years ago
19. Write a query to find a salesman with customers located in their cities.sql Adding SQL query language 4 years ago
20. Write a query to find all the salesmen for whom there are customers that follow them.sql Adding SQL query language 4 years ago
21. Write a query to display the salesmen which name are alphabetically lower than the name of the customers.sql Adding SQL query language 4 years ago
22. Write a query to display the customers who have a greater gradation than any customer who belongs to the alphabetically lower than the city New York.sql Adding SQL query language 4 years ago
23. Write a query to display all the orders that had amounts that were greater than at least one of the orders from October 9th 2012.sql Adding SQL query language 4 years ago
24. Write a query to find all orders with an amount smaller than any amount for a customer in London.sql Adding SQL query language 4 years ago
25. Write a query to display all orders with an amount smaller than any amount for a customer in London.sql Adding SQL query language 4 years ago
26. Write a query to display only those customers whose grade are, in fact, higher than every customer in New York.sql Adding SQL query language 4 years ago
27. Write a query to find only those customers whose grade are, higher than every customer to the city New York.sql Adding SQL query language 4 years ago
28.Write a query to get all the information for those customers whose grade is not as the grade of customer who belongs to the city London.sql Adding SQL query language 4 years ago
29. Write a query to find all those customers whose grade are not as the grade, belongs to the city Paris.sql Adding SQL query language 4 years ago
30. Write a query to find all those customers who hold a different grade than any customer of the city Dallas.sql Adding SQL query language 4 years ago