List all details of all shippers that the company is dealing

Assignment Help Database Management System

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.

Reference no: EM133569905

Questions Cloud

Retrieve the last two characters from the employees : Retrieve the last two characters from the employees' last names. Retrieve five characters from the employees' last names, starting at the second character

What tissue protects the human trachea : What tissue protects the human trachea and bronchial trees from collapsing during the pressure changes of breathing? Why don't the bronchioles have this?

Find out all the orders placed by all the customers : Retrieve all details of Orders administered by persons who hold the designation Sales Representative and shipped by United Package

Display the list of products that should be re-order : List out only 5 percentage of total records from customers table. Retrieve the Customer IDs and contact names of all customers who have yet to order

List all details of all shippers that the company is dealing : 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

What is negative pressure breathing : What is negative pressure breathing? Which main muscle groups are involved in inhalation and exhalation in humans?

Write SQL statements for the data retrieval operations : List all details of Customers with the output presented in descending order of Company names. Use Alias for each few columns of Customers and display Customers

Why its better to take a probiotic with few-only one strain : Why it's better to take a probiotic with few or only one strain?

Explain how they avoid overheating and desiccation : Explain how they avoid overheating and desiccation. Explain how they reduce the negative effects of cold temperatures.

User Account

All Pages