Reference no: EM133569905
Database Fundamentals
Tutorial - 1
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
List all details of all Shippers that the company is dealing with.
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.
Extract the information of employees having title (designation) as Sales Representative.
Retrieve the details of all orders made on 19 May 1997.
Retrieve details of all customers that are in the cities of London or Madrid.
Display all unique City from customer's table.
Display details of Products having unitprice in range of 100 to 200.
Display details of Products which unitprices are below 100 and above 200.
Display details of 'Ernst Handel' Customers
Display details of all Employees residing in USA or UK.