Data and Information Management

Database Interrogation. Week 8.

Student ID:

Student name:

Write SQL queries.

Open the Company database in the SQLite Browser and create the following SQL queries:

1. For each warehouse display a country and a city.

2. For each warehouse display a warehouse address, city, country, and a region name. In this query you need to use two tables: s_warehouse and s_region.

3. Display all customers with names starting from the letter ‘S’.

4. Display last names and userid of employees whose manager id is ‘2’ and salaries are less than $1600.

5. Display order ids with customer id is NOT ‘208’.

6. Display order id with order date starting later or on 1 September 2012.

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.