The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: First query—selecting columns from table Display the query objects in the database. For each of the…

A: To run the given select query and discuss the result.

Q: SQL query questions please no special functions. Table: create table sales cust varchar(20), prod…

A: SQL query questions please no special functions. Table:    create table sales   (     …

Q: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

Q: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY:  Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer  Group by CUS_CODE.

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: In sql get to know the HR database, its tables, and their contents. Show the SQL query and the…

A: SQL: SQL stands for a structured query language, it used to manage the data and organize the data in…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: introduction to databases Write PL/SQL code to create a function called best_ranked_post to list…

A: Create a function as mentioned above. Language SQL. Modifies SQL. Declare posts post function Set…

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber)  The partial functional dependency…

Q: The data set can contain many data tables Select one: True OFalse

A: A data set is an accumulation of linked, separate, tabularly presented related data items that can…

Q: Given two database table i_users(userid,username,email address,isActive,gender) stores the users…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: explaining why Column chart type selected and why this type was chosen. What is column chart

A: A column chart is a type of chart used to visualize data in the form of vertical columns. Each…

Q: 8. In the OrderItems table, display the minimum item_price with the alias shown. 2.49 1 rows…

A: Below is the complete solution with explanation in detail for the given question about writing query…

Q: ESTION Task 1: Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last…

A: Below the Sql query for this statement

Q: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

Q: Course Offering StudentiD : number (10) InstructoriD : number (10) CourselD : number (10) O Time :…

A: SMALLINT, INTEGER, BIGINT, NUMERIC(p,s), and DECIMAL(p,s) are the exact numeric data types.…

Q: CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…

Q: Normalise the data :

A: Q

Q: The table below lists customer/car hire data. Each customer may hire cars from various outlets. A…

A: The SQL statement to insert a record in the table is - INSERT INTO table_nameVALUES (val1, val2,…

Q: 5. In the OrderItems table, display a count of the number of products where item_price is greater…

A: Algorithm:From the OrderItems tableFrom the OrderItems tableWhere item_price is greater than or…

Q: The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City,…

A: Information provided: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and…

Q: 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”.…

A: The given problem is related to database SQL queries where the requirement is to create the table…

Q: 15:41 Done STUDENTS STUDENT_ID STUDENT_NAME S123456 S246810 S369121 S654321 S987654 MODULES…

A: CREATE TABLE STUDENTS(STUDENT_ID VARCHAR(20) PRIMARY KEY, STUDENT_NAME CHAR,STUDENT_SURNAME CHAR);…

Q: Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE…

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

Q: Display the total number of credits earned in each year using the tot credits (year, num credits)…

A: To explain this, we will assume that we have the following two tables:

Q: Task: UPDATE all employees salary in department 40 or 60 depending on their current salary range.…

A: To update the salary of the employee: below code below:

Q: SQL DML/DDL  There are five tables describing employees of a company, departments, buildings, which…

A: Creating tables and inserting values: create table Employee (EID number primary key, Ename text,…

Q: Table name: Supplier Column Name Role Data Type Length Constraint supplierID Stores the ID of…

A: Syntax : Alter table table_name Add column_name datatype , foreign key(col_name) references…

Q: a) Write in SQL a command that creates the table Products according to the above description (2…

A: Introduction: The syntax to create a table is shown below. CREATE TABLE table_name (    column1…

Q: Row trigger that gives the sum total before insert or update using sql

A: Find the required trigger given as below :

Q: Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login…

A: As per the requirement query is developed.

Q: Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following…

A: In the context of relational databases, this discussion revolves around the creation of an EMPLOYEE…