Product Name Sales Rep Country   Product 1 Paul China   Product 1 Paul Singapore   Product 1 John India   Product 2 Joe Canada   Product 2 Joe China   Product 2 Joe India   Product 2 Harry US   Product 3 Tom India   Product 3 Paul Japan   Product 3 Mike Japan   Product 4 Racheal US   Product 4 Paul Indonesia   Product 4 Mike Canada   Product 5 Stephen India   Product 5 Stephen Philippines           1. Sort table above first by Product (asc), Sales Rep (desc) and Country

Q: he following shows a training company’s workshops, the number of days of each, and their…

A: In this question we have to calculate and display the total cost of attending a workshop, including…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Problem 7 Write a query to produce the total number of hours and charges for each of the projects…

A: Here you have simply used the ROUND(value,2) function. This will simply round the value to 2 places…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: Show the employee dataframe after sorting by year join in descending order and by salary in…

A: Using R show the employee dataframe after sorting by year join in descending order and by salary in…

Q: Find the staff name who has the maximum salary for each branch Find the staff name who has the…

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: Change to use the database frozenfood Alter table customerOrder add column total as data type…

A: Note: As per our guidelines we can able to solve only three questions. So, please re-post the…

Q: For each department with more than one member of employee, find the sum of reward amounts for each…

A: The question is solved in step2

Q: Create 3nF relations for the table.

A: The key for the given relation is  (DepartmentNumber, customer number) The functional dependency…

Q: Most of the time, tables and data ranges are sorted in ascending sequence. When would you want to…

A: Sorting data is an important process in data analysis that involves organizing data in a specific…

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: You are designing a table for the Sales department. You need to include a column that contains each…

A: 1) You are designing a table for sales department, and you need to add column that contains sales…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.