Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Order Details Order D Product D UnitPrice Quantity EmployeeTerritories Employee D Territory D CustomerCustomerDemo Customer D Customer TypelD CustomerDemographics CustomerTypeD CustomerDex Customers Customer D

  

Order Details Order D Product D UnitPrice Quantity EmployeeTerritories Employee D Territory D CustomerCustomerDemo Customer D Customer TypelD CustomerDemographics CustomerTypeD CustomerDex Customers Customer D CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Territories TerritoryID TerritoryDescription RegionID Fax Orders Order D ! Customer D EmployeelD OrderDate Required Date Shipped Date Employees EmployeelD LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address ContactTitle Address ShipVia Products Product D ProductName Supplier D Category D QuantityPerUnit UnitPrice Unitsin Stock UnitsOnOrder ReorderLevel Discontinued Suppliers Supplier D CompanyName ContactName City Region HomePage PostalCode Country Phone Categories CategoryID CategoryName Description Picture Freight ShipName Ship Address ShipCity C City Region PostalCode Country HomePhone ShipRegion Extension ShipPostalCode Photo ShipCountry Notes Shippers Shipper D CompanyName Phone Reports To PhotoPath Region RegionID RegionDescription 1- Write a SQL statement to return all CategoryID from Products table which are not duplicated. 2- Write a SQL statement to return all fields from Products table. Sort the list by ProductName (in ascending order) and UnitPrice (in descending order). 3- Write one SQL statement to return CustomerID and CompanyName from Customers table, and OrderID and OrderDate from Orders table, and ProductID and UnitPrice from OrderDetails table. 4- Write a SQL statement to return the number of all Unit Price from Products table which is not NULL. 5- Write a SQL statement to return CategoryID, minimum UnitPrice, maximum UnitPrice and number of ProductID from Products table. Group them by CategoryID. 6- Write a SQL statement to return all CompanyName's having letter 'c' anywhere followed by any single letter then followed by letter 'x' from Customers table. 7- Write a SQL statement to return all CompanyName's having letter 'c' anywhere followed by any two letters then followed by letter "i' from Customers table.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

What is availability and how is it defined?

Answered: 1 week ago

Question

Propose a reasonable mechanism for the following reaction. OH

Answered: 1 week ago

Question

Define the eight characteristics of quality data.

Answered: 1 week ago