Database Interrogation

Database Interrogation

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

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!