Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Networking A Top-Down Approach

Authors: James Kurose, Keith Ross

7th edition

978-0133594140

More Books

Students also viewed these Computer Network questions