Below is the answer that I have but it is incorrect can anyone help?     select PROJ_NUM, ROUND(SUM(ASSIGN_HOURS),2) as 'TOTAL_HOURS', ROUND(SUM(ASSIGN_CHARGE),2) as 'TOTAL_CHARGE' from ASSIGNMENT -- from ASSIGNMENT table group by PROJ_NUM; -- group by to aggregate per PROJ_NUM

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Develop a simplified SQL query Display schedule_id, source, destination and travel_time which has…

A: For Sorting the results, ORDER BY is the keyword used Here, travel_time is referred with DURATION as…

Q: Name of subject: Database Programming     Display the name of supplier(s) that supplied more…

A: Approach: Step1: First find the max priced IBM make computer. this will be subquery. Step2: Write a…

Q: What is the result of the query below:   SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: Use the Committee table and create a query that displays the following output: Name FullAddress…

A: The query is given as per mysql in the next step:

Q: Q1: Show all the information from the employee table. SELECT * FROM emp; Q2: Show the employees…

A: The select statement is used to select a value from the database. The selected columns are displayed…

Q: The team wants to track potential list of users who may have forgotten their items on the cars.…

A: SELECT U.USER_FIRST_NAME, U.USER_LAST_NAME, T.TRAVEL_START_TIME, T.TRAVEL_END_TIME  FROM USERS U…

Q: SQL Querry Find the list of courses who haven’t got any section opened in Spring 2019. (Use outer…

A: It is simple SQL query to fetch the list of courses who haven't got any section opened in Spring…

Q: Describe any difficulties you may have when performing join operations with the NATURAL JOIN…

A: Answer:

Q: If a GROUP BY clause is included in a SQL query, the characteristics that may be sought in the…

A: In SQL ,If a select block does have a GROUP BY clause, any column specification specified in the…

Q: In each question below, you will define a new table based on the following tables.

A: The SQL question involves creating tables and sentences based on parent-child relationships, dog…

Q: SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride",…

A: Your SQL code contains error related to function datediff.

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts,  Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: If  the functional dependencies are consistent with the above relation,  put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related.  A-> B…

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: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: Write the relational algebra formula to apply an INTERSECT relational operator to the tables

A: Relational algebra formula for Intersect Relational Operator: An Intersect relational operator…

Q: Question 11. Write the SQL statement that will implement the relational algebra expressions in the…

A: The queries are given below

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: Given that there are two tables Employee and Orders. The attributes of each table are:…

Q: Minimum Travel Time Develop a simplified SQL query Display schedule_id, source, destination and…

A: Given: We are given a task to develop a SQL query to display schedule_id, source, destination and…

Q: Explain about in order and post order.

A: Traverse the right subtree, i.e., call Preorder(right-subtree) Uses of Preorder. Preorder traversal…

Q: The Driver Relationship team realized that maintaining driver IDs is difficult and requested an…

A: The objective of the question is to modify a database table to automatically increment the DRIVER_ID…

Q: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to…

A: Given: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides…

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Which clause can be used to restrict or filter the groups returned by a group function- based query?

A: To be determine: Which clause can be used to restrict or filter the groups returned by a group…

Q: 1. The data type for Borrower_name in Borrowers Table is: A. Short text C. Currency B. Long text D.…

A: As the schema design tabular structure of the Borrowers table in question indicates that it is…

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: hich one is correct Select the constraint (if any) that is violated by each the following operations…

A: Here table student_course contains primary key of table student and course.  Now we are deleting…

Q: Please help with the following What is a valid GROUP BY clause for the following SELECT list?…

A: Given:   Please help with the following What is a valid GROUP BY clause for the following SELECT…

Q: USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two…

A: sql select statement for above question is shown in step2

Q: write the query that updates the manager of the female employee who has 'c' as the last letter of…

A: Given : write the query that updates the manager of the female employee who has 'c' as the last…

Q: How does a parameter query differ from a select query?

A: A parameterized query is a sort of SQL query that expects somewhere around one boundary for…

Q: What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more…

A: The question asks to identify the primary keys and foreign keys for the "APARTMENTS" and "RENTERS"…