Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started