ITDA1001 Lab Tutorial 5
Task 1: Using Northwind Database, write SQL statements for the
following data retrieval operations.
Note: You may need to refer to the schema for the exact field names while framing the queries to the following
questions. While framing the question, the words ‘code’, ‘number’ or ‘ID’ may have been synonymously used. For
instance, ‘Customer Number’ when used may refer to a field called CustomerID. Similarly, wherever the word ‘name’
is used, appropriate interpretation may be needed based on the schema – for instance if ‘customer name’ is required
to be printed, you may need to retrieve CompanyName field from the Customers Table; likewise, when ‘employee
name’ is required (without any further qualification, you may retrieve the lastname field of Employees table.
Exercise
5.1 List all details of all Shippers that the company is dealing with.
5.2 List the all employees – you need to display only the details of their First Name, Last Name,
Title, Date of birth and their city of residence.
5.3 Extract the information of employees having title (designation) as Sales Representative.
5.4 Retrieve the details of all orders made on 19 May 1997.
5.5 Retrieve details of all customers that are in the cities of London or Madrid.
5.6 Display all unique City from customer’s table.
5.7 Display details of Products having unitprice in range of 100 to 200.
5.8 Display details of Products which unitprices are below 100 and above 200.
5.9 Display details of ‘Ernst Handel’ Customers
5.10 Display details of all Employees residing in USA or UK.
Copyright © 2022 VIT, All Rights Reserved. 2