This website works better with JavaScript.
Explore
Help
Sign In
michael
/
programming-examples
Watch
1
Star
0
Fork
You've already forked programming-examples
0
Code
Issues
Pull Requests
Releases
Wiki
Activity
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.
master
master
Branches
Tags
${ item.name }
Create tag
${ searchTerm }
Create branch
${ searchTerm }
from 'master'
${ noResults }
programming-examples
/
sql
/
Union
History
Michael Reber
8c9a19ec97
Adding SQL query language
4 years ago
..
1. Write a query to display all salesmen and customer located in London.sql
Adding SQL query language
4 years ago
2. Write a query to display distinct salesman and their cities.sql
Adding SQL query language
4 years ago
3. Write a query to display all the salesmen and customer involved in this inventory management system.sql
Adding SQL query language
4 years ago
4. Write a query to make a report of which salesman produce the largest and smallest orders on each date.sql
Adding SQL query language
4 years ago
5. Write a query to make a report of which salesman produce the largest and smallest orders on each date and arranged the orders number in smallest to the largest number.sql
Adding SQL query language
4 years ago
6. Write a query to list all the salesmen, and indicate those who do not have customers in their cities, as well as whose who do.sql
Adding SQL query language
4 years ago
7. Write a query to that appends strings to the selected fields, indicating whether or not a specified salesman was matched to a customer in his city.sql
Adding SQL query language
4 years ago
8. Write a query to create a union of two queries that shows the names, cities, and ratings of all customers. Those with a rating of 300 or greater.sql
Adding SQL query language
4 years ago
9. Write a query that produces the name and number of each salesman and each customer with more than one current order. Put the results in alphabetical order.sql
Adding SQL query language
4 years ago