Question: Answer the following question in SQL queries using the diagram above: 1) Create a report of all staff and their manager. Column listings are: Staff

Answer the following question in SQL queries using the diagram above:

1) Create a report of all staff and their manager. Column listings are:

Staff Full-Name Manager Full-Name

2) Create a report that shows all brands and the number of products each has. The two columns listings are: Count of Products Brand Name

3) Create a report with customers living in Texas or California. The three columns listings are:

Customer's Full-Name Customer's City and State E-mail Address

Staff (Sales) Orders (Sales) Onderld Orderltems (Sales) Onderld Customers (Sales) Stores (Sales) toreName ZipCode Brands (Production) Stocks (Production) Products (Production) Brandld Stored Productii Quantity Brandld Categoryld Modelar ListPrice Categories (Production) Staff (Sales) Orders (Sales) Onderld Orderltems (Sales) Onderld Customers (Sales) Stores (Sales) toreName ZipCode Brands (Production) Stocks (Production) Products (Production) Brandld Stored Productii Quantity Brandld Categoryld Modelar ListPrice Categories (Production)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

the assigment is to answer the following question in 700-800 words using harvard refrencing to the case study below. Compare employee job satisfaction in the Medical Records and Accident and...

Graffiti Busters Lab 2A DDL Objectives: 1. Given an ERD, define tables and constraints on the data, using the Create Table statement in SQL Server. 2. Alter the definition of an existing table using...

please answer in java and the output should be same as the sample out. please answer the question ASAP Sample output A school management system contains three classes, i.e., the Staff class, the...

This is for a course called intro to databases. In this assigment you need to design a database that maintain all the "Contracts" of a company. The Contract Management System (CMS) will serve the...

Please answer the following question after reading the case study which is attached below: How much PM is enough PM? How much PMO support is enough PMO support? The AtekPC Project Management Office...

Question 1 Mastery Problem: Variable Costing for Management Analysis Question Content Area Absorption vs. Variable Operating income is one of the most important items reported by a company. Depending...

Ozhouse Clean is based in Melbourne and offers professional, residential cleaning services, including regular home cleans, as well as spring cleans. The company was established in 2005 and is a...

Assessment 1 - Case study For this assessment you are going to use the 'simulated 'business: 'Blue fish grill.' Please download the copy of the customer service policies and procedures manual that...

Kindly answer the following question from facility management without explanations : in which of the following project phases are a project's end results identified? a. Define b. Do c. Plan d. Act An...

please need answer in java code and it could be very greatful if any can give correct java code answer as per the requirement and the result should be like the one in the output. please do it ASAP...

Consider the differences in retail concentration between the United States and Europe. How do those differences impact on manufacturers channel strategies?

Boys growth charts indicate that height of eight-year-old boys is approximately Normal with mean 48 inches and standard deviation 2.1 inches. a. What is the probability that one randomly selected...

the average annual increase of foreign direct investments in the united states has been what percentage? a ) 1 0 % b ) 1 3 % c ) 1 6 % d ) 1 9 %

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1. I can read fellow team members true feelings, even if they try to hide them.

3. Using Frischs process to avoid defaulting to the manager, how will you help the team make recommendations?

5. What information would the team members need?