Database Fundamentals – Assignment 2
Basic Joins
- Find the names of all single un-married male employees currently working for the company
- Find the First and Last name of all customers who have purchased items in the database
- Find the names of all employees who currently work in the Production Department
- Find the names of all Business Contacts in the Database
Hard Joins
- Find the names of all current employees and their departments who are salaried employees (exempt from collective bargaining).
- Find the names of all current employees that work in departments other than the sales department.
- Find the names of bicycle stores in Victoria Australia
Aggregates
- Calculate the number of employees currently working in each different department
- Find the names of all stores that have more than one address on record.
- Count the number of customers without an address on record.
Hard Aggregates
- Find the state in Australia with the most bicycle stores for this company.
- Find the names and sales quota of the stores that have the highest sales quota of all stores and whose store name starts with the letter ‘C’. MAX should be SUM as this is finding the store with the person with the highest sales quota.
- Find the number of Job Candidates with known departments including those whose department cannot be determined. Use the words “Unknown” for candidates where the department cannot be determined.
Sub Queries
- Find the names of all customers without an address on record
Set Operators
- Give a list of First and Last Names of all people that have the same First and Last Name of someone who lives in Australia.