Construct an sql statement to find the products

Assignment Help Database Management System

Reference no: EM133802111

Tutorial 5

In this tutorial, we will focus on using SQL statements to perform data selection within the Northwind database, which was provided in Tutorial 3.

Task 1

Construct an SQL statement to find the total number of products in stock for each category

Task 2

Construct an SQL statement to retrieve a list of all product names along with the corresponding suppliers, this list is sorted by product names in ascending order. Get Personalised Assignment help Now!

Task 3

Construct an SQL statement to display a list of city names along with the number of customers in each city, sorted in descending order based on the number of customers.

Task 4

Construct an SQL statement to find the products that have the highest price within their categories. Display the product name, category name, and unit price.

Task 5

Construct an SQL statement to display the employee ID, first name, last name, and the number of territories he/she manages, with the results sorted by the number of territories in descending order.

Note: For Lab Exercise 1, you are required to submit a Microsoft Word file that includes the following:
A cover page
Solutions for 5 tasks, with each solution including:
- The SQL statement (in plain text) with a brief description of how it works
- A screenshot showing the results of executing the SQL statement

Reference no: EM133802111

Questions Cloud

What evidence does author use to present their point of view : What evidence does the author use to present their point of view? Identify one writing strategy (rhetorical mode) the author uses to make their argument?

Current nursing policies and issues : Stay Informed and Educated: Keep up-to-date with current nursing policies and issues.

Age-related physiological and psychological symptom : Formulating diagnoses according to DSM 5-TR based on assessment data Differentiating between normal/abnormal age-related physiological and psychological symptom

What are the anticipated outcomes for your picot question : What are the anticipated outcomes for your PICOT question? How do the outcomes of the four articles you chose compare to your anticipated outcomes?

Construct an sql statement to find the products : Construct an SQL statement to find the products that have the highest price within their categories. Display the product name, category name, and unit price

Medical information and planning communication agenda : Reviews the patient's medical information and planning the communication agenda which may require a family meeting and follow-up conversations

Patient preference for family involvement : Determines who is the right person to talk to about end-of-life issues and the patient's preference for family involvement

Patients with end-stage life-threatening illness : Hospice services are an option for patients with end-stage life-threatening illness. These services are covered by Medicare, Medicaid,

Critically evaluate the processes and outcomes : IMA7001 International Marketing Management, University of Bolton - Critically evaluate the processes and outcomes in the implementation of the global marketing

User Account

All Pages