Data and Information Management

Database Interrogation. Week 10.

Student ID:

Student name:

Write SQL queries.

Open the ‘Week_9_DW_example.db’ database that we used in weeks 9 and 10 workshops. It can be downloaded from page ‘9.4 In-class activity: Data Warehouse’ in Canvas.

Create the following SQL queries:

1. Display product names and their prices with the prices in the range from $40 to $60 inclusive.

2. Display supplier names starting from the letter ‘P’

3. Display names of Orange suppliers

4. Display a total amount of supplied Oranges.

5. Display product names, their prices and their supplier names for all products delivered in June 2018.

You need to follow to the ‘Good practice style’ of SQL writing:

· Write SQL commands in capital letter where appropriate

· Use aliases for column names

WHAT TO SUBMIT:

1. Copy and paste the queries in THIS MS Word document. For example:

SELECT last_name AS [LAST NAME], first_name AS [FIRST NAME] FROM s_emp

2. For each query, take a screen image of the output and paste it in THIS document

Example:

Submit your solution to Database Interrogation Assessment in Canvas before the end your class.