Order Details Order D Product D UnitPrice Quantity EmployeeTerritories Employee D Territory D CustomerCustomerDemo Customer D...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Explain what is meant by employee relations and what employers can do to improve it. Include in your discussion how employers can deal with employee treatment during layoffs and/or mergers. 2. Using...
-
Suppose there are two identical forest plots except that one will be harvested and left as is while the second will be cleared after the harvest and turned into a housing development. In terms of...
-
What is manufacturing lead time?
-
Evaluate each expression. (Simplify your answers completely.) (a) 43.4 X (b) 94.9-2 X Simplify by evaluating exponents. (c) (22)3
-
A composite shaft is fabricated by bonding an isotropic solid shaft having shear modulus \(G_{1}\), and outside radius \(r_{1}\), inside a hollow isotropic shaft having shear modulus \(G_{2}\) and...
-
Rubin, was driving on one of the citys streets when he inadvertently obstructed the path of a taxicab, causing the cab to come into contact with his vehicle. Angered by the Rubins sudden blocking of...
-
Your company would like you to help create a model for calculating Customer Lifetime Value for a cohort. Using figure 2.5 as a starting point, help create a model in Excel that will calculate 10-year...
-
Find any 3 research papers related to the topic "Parking Management system using 8086 microprocessor". The research papers should be after year 2019 and above. Paste the proper link with abstract.
-
What colour change do you observe in the biotransformation of L-tryrosine to L-DOPA over time? What causes the colour change?
-
Explain how you would use industry information and corporate disclosures to forecast a company's future financial results.
-
Johnstown Company granted 1 0 officers rights to buy 1 0 , 0 0 0 shares each of common stock $ 1 par, at $ 1 5 per share on May 1 , 2 0 2 4 , the grant date. The stock was selling for $ 1 0 per share...
-
ESSAY-4-5 pages Upward economic mobility is difficult to attain in this country. You implicitly know this; that's why you've come to college. But just being in college isn't enough. How can you...
-
Article Analysis essay about Two Articles: "The Forms of Capital" - by P. Bourdieu and "Whose Culture has Capital?" - by T. Yosso essay Discussing each author's perspectives on "capital?" Next...
-
Hamlet has its roots in the Elizabethan revenge play. yet the play seems not to be much about revenge that takes place only in the last seconds of a very long production. Perhaps its more a play...
-
In a large midwestern university, 30% of the students live in apartments. If 200 students are randomly selected, find the probability that the number of them living in apartments will be between 55...
-
Companies are facing a great amount of change in every facet of their operations today. To remain competitive, companies must keep abreast of current developments in several areas. You recently got...
-
For each of the situations listed, identify the primary standard from the IMA Statement of Ethical Professional Practice that is violated (competence, confidentiality, integrity, or credibility.)...
-
Sustainability involves more than just the impact of actions on the environment. The triple bottom line recognizes that a company has to measure its impact on its triple bottom line for its long-term...
Study smarter with the SolutionInn App