Question: Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all

Q.6.3.4 Write a SQL statement to get a list of the tasksin the database, arranged by duration from largest to smallest. Include all

Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all the columns from the Task table. Q.6.3.5 Write a SQL statement to get the total duration of all the tasks that start between 2022-05-01 and 2022-05-31 (both inclusive). Q.6.4 Assume that all the statements from Q.6.2 have been executed on the database. Determine the results of the below query. Explain how the result was calculated. -- Q.6.4 SELECT TeamMember ID, SUM(Duration) FROM Task WHERE Duration > 1 GROUP BY TeamMember ID; Primary key: TeamMemberlD TeamMemberID TeamMemberName 1 2 3 TeamMemberEmail Joe Bloggs joe@theoffice.com Samantha Smith sam@theoffice.com Pete Ngwenya pete@theoffice.com Table: Task Primary key: TaskID Foreign key: Team MemberlD TaskID Description Duration StartDate TeamMemberID 1 Build login screen 4 2022-05-06 1 2 Implement inventory 10 2022-05-15 1 management 3 Add logo to splahs 1 2022-05-06 2 screen

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 Computer Network Questions!